Viewing 15 posts - 61 through 75 (of 90 total)
Savepoints offer a mechanism to roll back portions of transactions. You create a savepoint using the SAVE TRANSACTION savepoint_name statement. Later, you execute a ROLLBACK TRANSACTION savepoint_name statement to roll...
December 22, 2009 at 9:03 am
jim.taylor (11/30/2009)
...if DateTime is only precise to 3.33 ms, why then is the answer just 1 ms off? Why not 3 ms?
When the SELECT output's ms aspect can be...
November 30, 2009 at 8:38 am
I had no idea that 'sp_helpdb' returned more than the "name"s of the databases (my iSQLw results are "to text," the "name"-column output takes up the entire window, and I...
November 10, 2009 at 8:24 am
majorbloodnock (11/9/2009)
Which of these seven queries will return "Date is Null"? (select all that apply)
Was that a zero-based list? ;-):-D
Noticed that, but since the PRINT statements utilize 1 through 8,...
November 9, 2009 at 9:29 am
Mark Harr (10/29/2009)
Shoot! I had the identity increment right, but forgot about truncate table resetting the seed value.
There was a recent question which brought that point out (maybe Mark...
October 29, 2009 at 8:12 am
kramaswamy (10/29/2009)
bah. automatically assumed it was seeded with increments of 1. i've never used a non-1 increment personally :/
Ditto :-).
October 29, 2009 at 8:10 am
slange-862761 (10/28/2009)
Good point. The real deal is that the datatype was implicity set to have 4 decimal places and the round function will not change the datatype....
Exactly. You can...
October 28, 2009 at 9:28 am
I gained both from the article's graphic examples and from its use of SCOPE_IDENTITY() in INSERTing rows into the 1st table. Thanks to whomever (Steve Jones?) made the requisite...
October 23, 2009 at 9:32 am
duda (10/21/2009)
What you don't know won't hurt you...
Well, I didn't know the answer to this Q :-).
October 21, 2009 at 9:25 am
I thought the question was a fair one, especially as I'm in the minority of listmembers who chose the answer wisely :-), but I really wanted to say "Thank you"...
October 16, 2009 at 8:53 am
Chris Houghton (10/8/2009)
It's a SQL Server 2005 or above question pal. It won't work on 2000. That wasn't very clear in the question though.
It was a good Q...
October 8, 2009 at 9:07 am
dave.farmer (9/16/2009)
Is this not a case of:
if (condition) or (condition)
then
else
That's just an if-then-else statement.
Both conditions equate to false,...
September 16, 2009 at 8:21 am
john.arnott (9/14/2009)
Michael Poppers (9/14/2009)
September 15, 2009 at 10:43 am
Thanks for the question! I didn't know that division by zero was technically OK in T-SQL in certain situations (like when the dividend is undefined). Since it is,...
September 14, 2009 at 8:31 am
Viewing 15 posts - 61 through 75 (of 90 total)