Viewing 15 posts - 16 through 30 (of 51 total)
A variation of this question could be:
DECLARE @inc int, @dec int;
SELECT @inc = 1, @dec = 10;
DECLARE @temp table (StringA varchar(20), StringB varchar(20));
WHILE @inc <= 10
BEGIN
INSERT...
December 11, 2009 at 7:45 am
Sorry about the bool. [bool happens to be a user defined data type on the database I was working on while framing this question], that should be char(1)
October 30, 2009 at 6:48 am
Damn, I knew how this would work, and noticed the increment 3 too. My mind kinda' swapped the DELETE and TRUNCATE. Chose 4.
October 30, 2009 at 5:54 am
pdanke (7/14/2009)
The fact that there were any votes for the "delete Resource database" option was a bit scary.
88 people opted this answer till now! :w00t:
July 15, 2009 at 12:54 am
This was a nice thing to learn! Thanks to all for the Boquets in this one and Brickbats in others! 😉
July 8, 2009 at 4:03 am
Yes, it definitely helped. Thanks a lot guys!
June 18, 2009 at 7:35 am
Pyay Nyein (6/18/2009)
SQL Server returns the resultset which it can return fastest. So it would be that 4 is fastest to return for this statment.
What do you...
June 18, 2009 at 4:20 am
Viewing 15 posts - 16 through 30 (of 51 total)