Viewing 15 posts - 13,801 through 13,815 (of 15,381 total)
So I have to ask...why not just use top? That is the purpose of it. Or did your professor tell you come up with a different way? There are a...
October 7, 2011 at 7:37 am
WOW that is a seriously old version. Maybe you can export your data to file first and then import to sql? I don't know that I can be much help....
October 7, 2011 at 7:21 am
RP_DBA (10/6/2011)
faruk.arshad (10/6/2011)
@old handbut i have the inner condition if @@rowcount=0 then break then shouldnt go infinite......
Yep, my bad.
No you were correct. This will never break out of...
October 6, 2011 at 2:12 pm
faruk.arshad (10/6/2011)
@old handbut i have the inner condition if @@rowcount=0 then break then shouldnt go infinite......
@sean
Curser ?? can u write sample query of it ?
Yes you could use...
October 6, 2011 at 1:51 pm
faruk.arshad (10/6/2011)
yes i know tat ..but i want to use loop becoz want clear looping concept in SQL jst pretty mch confuse in it..
Just my 2¢ but since you...
October 6, 2011 at 1:43 pm
Lynn Pettis (10/6/2011)
Eddie Wuerch (10/6/2011)
IF NOT EXISTS(SELECT * FROM Customer WHERE col1 = @x AND col2 = @y AND @col3 = @z)BEGIN
-- do stuff
...
October 6, 2011 at 1:36 pm
faruk.arshad (10/6/2011)
== == ===
123
13NULL
14NULL
15NULL
16NULL
17NULL
123
13NULL
14NULL
15NULL
16NULL
17NULL
i have this table i want to update the...
October 6, 2011 at 1:33 pm
LOL Aside from the comment looks like Eddie and I answered with the exact same thing.
October 6, 2011 at 1:31 pm
SQL_Padawan_Learner (10/6/2011)
Table: CUSTOMER
Columns: col_1, col_2, col_3
What I need is a statement that says IF col_1 = X, col_2 = Y and col_3 = Z in...
October 6, 2011 at 1:30 pm
GSquared (10/6/2011)
Sean Lange (10/6/2011)
Jack Corbett (10/6/2011)
Never really listened...
October 6, 2011 at 12:56 pm
Dig around on google and find instructions for creating a 32bit DSN on a 64bit box. Let me know if you run into any issues. Wish I had time to...
October 6, 2011 at 12:39 pm
Are you trying to install a DSN? You need a 32bit DSN and the tool in the control panel is installing a 32bit driver. There is a way to install...
October 6, 2011 at 12:34 pm
Jack Corbett (10/6/2011)
Never really listened to the Ramones,...
October 6, 2011 at 12:30 pm
Stefan Krzywicki (10/6/2011)
Sean Lange (10/6/2011)
Stefan Krzywicki (10/6/2011)
Grant Fritchey (10/6/2011)
Steve Jones - SSC Editor (10/6/2011)
A sad day, and a reminder...
October 6, 2011 at 12:27 pm
Grant Fritchey (10/6/2011)
Time to start the education. Quintessential Ramones. But my own preference is for this.Hurry, hurry, hurry...
...too late I already went insane.
October 6, 2011 at 12:21 pm
Viewing 15 posts - 13,801 through 13,815 (of 15,381 total)