Viewing 15 posts - 1 through 15 (of 39 total)
Carlo Romagnano (9/22/2010)Some operations have no sense inside a transaction. I surprise to see so many wrong answers.
Carlo Romagnano (9/22/2010)
For me, it came down to a guess between would it just do...
September 22, 2010 at 8:36 am
CirquedeSQLeil (9/21/2010)JF1081 (9/21/2010)Would COMMIT TRAN OuterTran without the use of COMMIT TRAN InnerTran commit both transactions?Yes it does.
JF1081 (9/21/2010)Would COMMIT TRAN OuterTran without the use of COMMIT TRAN InnerTran commit both transactions?
COMMIT TRAN OuterTran
COMMIT TRAN InnerTran
Yes it does.
Thanks, and I hope I did not just ruin Part IV.
September 22, 2010 at 8:33 am
Would COMMIT TRAN OuterTran without the use of COMMIT TRAN InnerTran commit both transactions?
September 21, 2010 at 9:18 am
Can anybody point me to a tutorial or set of instructions on how to create a simple nightly backup for SQL server 2008 express? It is not a large...
September 16, 2010 at 10:09 am
At first I thought 3,1, but since that was not an option I came to my senses and realized that varchar does not adjust if the string is too big.
August 23, 2010 at 9:56 am
Lol, I saw the word "definitely" and immediately thought: nope, it depends. I have no substantial backing for that thought as I know nothing about computed columns, but I...
July 21, 2010 at 7:59 am
UMG Developer (7/6/2010)
I'm a little surprised that so many people have gotten it correct so far, but that may be because of the copy, paste, F5 syndrome....
July 7, 2010 at 9:06 am
The question presented in the email had:
mainkey int not null identity (-1,1)
but the code in the question and answer on the web site had:
mainkey int not...
June 30, 2010 at 11:16 am
June 28, 2010 at 8:34 am
Why is the answer 'C'? Could it be possible that the query would return 'A' or 'B'?
June 25, 2010 at 10:02 am
Personally, I thought it was a trick trick question. Too easy to be that easy, but the writer was expecting me to think that so I decided it was...
June 17, 2010 at 9:17 am
The problem with questions based on syntax errors is that the person answering the question does not know if the syntax error is the issue or if the question is...
June 11, 2010 at 9:34 am
WayneS (4/27/2010)I was a little bit disappointed that the answer went into how a datatime data type is stored in two ints, and did not discuss why "1" = "1900-01-02".
April 27, 2010 at 7:45 am
Tao Klerks (4/22/2010)
April 22, 2010 at 8:18 am
I googled Topeka'ed it and the first item returned was a SQL server central thread. The link took me to the middle of the thread and I thought to...
April 1, 2010 at 7:56 am