Database

Re: Difference between Correlated and Simple Subqueries

4-Apr-08 0:22

is this your question What is difference between Co-related sub query and nested sub query?
then might be the answer http://www.geekinterview.com/question_details/17300[^]

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.

pmarfleet4-Apr-08 0:35

pmarfleet

4-Apr-08 0:35

.NET- India wrote:
Please Friend dont give this type of answers.

What do you mean? I gave you an answer to your question.

If you don't know how to use a search engine to find answers to questions, I suggest you read this article[^]. Being able to use a search engine is pretty much a prerequisite for being a developer, so I suggest you learn fast.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Incorrect syntax near stored procedure

Krazy Programmer3-Apr-08 23:36

3-Apr-08 23:36

hi I am using sql 2000 as database and windows form done in c# as the interface

I am having some 8 stored procedures in the project all are working fine except 1
Error which i got is ("Incorrect Syntax near SP_drivers")
i have checked it in DB by inserting values its working fine
but through interface its giving error
Thanks in Advance

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.

Pete O'Hanlon3-Apr-08 23:53

Pete O'Hanlon

3-Apr-08 23:53

Without seeing your C# code, it's hard to say what the problem could actually be.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Krazy Programmer4-Apr-08 0:03

4-Apr-08 0:03

its a bog code from here just i am passing parameters

connection = new SqlConnection(sql);
command = new SqlCommand("SP_Driver_WMile_Desc", connection);
connection.Open();
if (availability == true)
command.Parameters.AddWithValue("@Mode", "U");
else
command.Parameters.AddWithValue("@Mode", "I");
command.Parameters.AddWithValue("@Rate_ID", selected_node_parent);
command.Parameters.AddWithValue("@Vehicle_ID", selected_node);
command.Parameters.AddWithValue("@Drv_rate_ID", selected_driverrate);
if (rbtnWaitingDriverprice.Checked == true)
command.Parameters.AddWithValue("@Driver_Round_Type", true);
else
command.Parameters.AddWithValue("@Driver_Round_Type", false);
if (cboxWaitingDriver.SelectedItem.ToString() == "Up")
command.Parameters.AddWithValue("@Driver_Rounding", true);
else
command.Parameters.AddWithValue("@Driver_Rounding", false);

if (txtWatingDriverNearest.Text == "")
txtWatingDriverNearest.Text = "0";

command.Parameters.AddWithValue("@Driver_Nearest", txtDrivertonearest.Text);

for (i = 1; i <= 10; i++)
{
if (Waiting_Driver_Gridview[0, i - 1].Value == "")
command.Parameters.AddWithValue("@Driver_Mile_Box_" + i.ToString(), 0.00);
else
command.Parameters.AddWithValue("@Driver_Mile_Box_" + i.ToString(), Convert.ToDouble(Waiting_Driver_Gridview[0, i - 1].Value));
}

for (i = 1; i <= 10; i++)
{
if (Waiting_Driver_Gridview[1, i - 1].Value == "")
command.Parameters.AddWithValue("@Driver_Charge_Box_" + i.ToString(), 0.00);
else
command.Parameters.AddWithValue("@Driver_Charge_Box_" + i.ToString(), Waiting_Driver_Gridview[1, i - 1].Value);
}
command.ExecuteNonQuery();
connection.Close();
MessageBox.Show("Data Added Successfully ", "Data Adition", MessageBoxButtons.OK, MessageBoxIcon.Information);
}

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.

Pete O'Hanlon4-Apr-08 1:31

Pete O'Hanlon

4-Apr-08 1:31

You don't have anything in your code to tell it that you are using a stored procedure. You need to set the command type to CommandType.StoredProcedure. By default, it will try to execute this as a straight forward piece of SQL.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Krazy Programmer4-Apr-08 2:06

4-Apr-08 2:06

Thank You very much ...actually got exhausted today because of heavy work

thank you once again

Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.

HP 6767 NoteBoOk sql sERVER 2005

Pete O'Hanlon4-Apr-08 2:15

Pete O'Hanlon

4-Apr-08 2:15

No problem. Glad to help.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Piyush Vardhan Singh3-Apr-08 22:34

Piyush Vardhan Singh

3-Apr-08 22:34

I have HP 6767 (with vista OPerating system) NoteBook and SQL Server 2005 inbuild in opertaing system . but i can not access sql sever2005 so how i can access sql Please help me.

Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com

Re: HP 6767 NoteBoOk sql sERVER 2005

Colin Angus Mackay4-Apr-08 0:27

Colin Angus Mackay

4-Apr-08 0:27

Piyush Vardhan Singh wrote:
and SQL Server 2005 inbuild in opertaing system

If you cannot access it, how do you know it is there?

Upcoming FREE developer events:
* Developer Day Scotland

Recent blog posts:
* Mixins in C#3.0

My website | Blog

Re: HP 6767 NoteBoOk sql sERVER 2005

blackjack21504-Apr-08 2:23

blackjack2150

4-Apr-08 2:23

Use SQLCMD tool: http://www.databasejournal.com/features/mssql/article.php/3654176[^]

Also, I think there's an Express Version for Management Studio.

Edit multiple rows at once

Yevgeny Efter3-Apr-08 20:38

Yevgeny Efter

3-Apr-08 20:38

Hello!

I have a table which has a text column.

I need to modify this column for all rows that begin with some text.

How can I do it?

Thanks in advance!

Have a nice day!

Re: Edit multiple rows at once

A Wong4-Apr-08 2:42

A Wong

4-Apr-08 2:42

UPDATE table_name
SET column_name = new_value
WHERE column_name like '%some text'

You should really read up on SQL if you have to ask this kind of questions. I suggest you read w3schools[^] articles on sql.

why it is not work

tittly3-Apr-08 17:03

tittly

3-Apr-08 17:03

i write store procedure for the time .it insert time in the database before inserting it check this time is already
exit or not .if exit it not allow me to insert and rasise error

butit not work it give error on starting "begin" statement

i don't understand where i am doing wrong
someone help me to reconver this error

CREATE PROCEDURE InsertTiming(@timing nvarchar(255))
BEGIN
SET NOCOUNT ON;

-- Check if timing already exists
DECLARE @tmp nvarchar(255);
SELECT @tmp = s_time FROM timing WHERE s_time = @timing;
IF @tmp IS NOT NULL
BEGIN
raiserror(N'Timing %s already assigned',
10,
1,
@timing);
END

-- Insert new value
INSERT INTO timing(s_test) VALUES (@timing);
END

okey

Re: why it is not work

SimulationofSai3-Apr-08 18:29

SimulationofSai

3-Apr-08 18:29

MSDN : CREATE PROCEDURE[^]

In short, you're missing the AS keyword before BEGIN.

SG
Cause is effect concealed. Effect is cause revealed.

Re: why it is not work

tittly3-Apr-08 19:34

tittly

3-Apr-08 19:34

i use as statement

but it give me error on

@timing

okey

slow updating

Xmen Real 3-Apr-08 16:18

Re: slow updating [modified]

3-Apr-08 16:18

hello there,
im updating my table of about 1300 rows through C# but i always got error that server time out, then i copied the query and executed in the sql, and it took 25 secs that is too much

the query is written something like this :

update mytable set id = '1100001',deptid = 1, Cid = 1 where id = 'A1100001'
update mytable set id = '1100002',deptid = 1, Cid = 1 where id = 'A1100002'
update mytable set id = '1100003',deptid = 1, Cid = 1 where id = 'A1100003'
.
.
.
.

here are around 1300 lines like this,
about table
id nvarchar(25) PK
deptid tinyint
Cid tinyint

any idea how to speed up?? because 25 secs with core2 processor is too much

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can

Blue_Boy3-Apr-08 18:59

Blue_Boy

3-Apr-08 18:59

declare @i as int <br />
set @i=0<br />
declare @value as varchar(50)<br />
set @value='1100000'<br />
declare @newvalue as varchar(50)<br />
set @newvalue=''<br />
declare @Avalue as varchar(50)<br />
set @Avalue='A1100000'<br />
<br />
while @i<=1300 <br />
begin<br />
	set @i=@i+1<br />
	<br />
	set @newvalue = substring(@value,1,len(@value)-len(convert(varchar,@i)))+''+convert(varchar,@i)<br />
	set @Avalue = substring(@Avalue,1,len(@Avalue)-len(convert(varchar,@i)))+''+convert(varchar,@i)<br />
	select @newvalue<br />
	update mytable set id = @newvalue,deptid = 1, Cid = 1 where id = @Avalue<br />
end

I Love SQL

modified on Friday, April 4, 2008 1:20 AM

Re: slow updating [modified]

Xmen Real 3-Apr-08 22:27

3-Apr-08 22:27

may i ask what is the difference ?, you are also updating like this Frown | :(

update mytable set id = @newvalue,deptid = 1, Cid = 1 where id = @Avalue

thanks

modified on Friday, April 4, 2008 4:40 AM

Blue_Boy4-Apr-08 7:22

Blue_Boy

4-Apr-08 7:22

did u try if it is more effective?

I Love SQL

Xmen Real 4-Apr-08 7:25

4-Apr-08 7:25

no, i cant use that way, because im making query from C#, where id is not in sequence, it can be A923 or A382

Blue_Boy4-Apr-08 8:01

Blue_Boy

4-Apr-08 8:01

oh OK, sorry on my unusefull answer...
did u indexed fields of table?

I Love SQL

Xmen Real 4-Apr-08 14:51