Viewing 15 posts - 2,746 through 2,760 (of 3,347 total)
I got it right, by focusing on the WHERE clause (that alone dictates the number of rows), and hoping that there was no parentheses mismatch or similar error buried in...
July 2, 2010 at 2:24 am
krishnaroopa (7/1/2010)
Also, why not it work like this:'-' being string,
other two can implicitly convert to string?
They can, but they won't. SQL Server uses well-defined rules for data type precedence...
July 2, 2010 at 1:57 am
hrvoje.piasevoli (7/1/2010)
But that does not make this the recommended method to disable all triggers in a database. As can be read in the documentation that is referenced in the explanation,...
July 1, 2010 at 5:26 am
Given the answer options, I agree that the sp_foreachtable option was the only correct one.
But that does not make this the recommended method to disable all triggers in a database....
July 1, 2010 at 4:17 am
Open Minded (7/1/2010)
. 6+2+-+7...
July 1, 2010 at 1:50 am
Good question. The only thing I dislike about it is the description "PRINT vagaries" because, as others have noted, the PRINT statement is completely innocent.
A better name would have been...
June 30, 2010 at 3:05 am
hilld (6/29/2010)
Ok, they changed the question. How do I change my answer now?
You can't. You always have to check the question on the website before answering. I believe there...
June 29, 2010 at 8:04 am
hilld (6/29/2010)
It still says that -1,0,1 is wrong.
I've said it before, I'll say it again - the question has been changed.
Read the changed text of the question on the website....
June 29, 2010 at 7:45 am
mzettler (6/29/2010)
June 29, 2010 at 7:02 am
I, too, chose the "none of the above" answer.
In addition to the links already posted by other contributors, here is a third one:
"Microsoft has estimated the entire impact of TDE...
June 29, 2010 at 3:09 am
paul s-306273 (6/29/2010)
Perhaps we need some Quality Control on QOD.Changing the question after people have started submitting answers - that seems a bit unfair to me...
Maybe you should read the...
June 29, 2010 at 2:28 am
sunitagaikwad (6/28/2010)
i am getting -1, 0, 1how come u r getting -1,-2,-3 ? pLz explain.......
There was a typo in the question, that has been corrected after the newsletter was sent...
June 29, 2010 at 1:30 am
kevin.l.williams (6/28/2010)
June 28, 2010 at 10:14 am
Duncan Pryde (6/28/2010)
Although I knew that you can have negative seeds and increments for the IDENTITY property, I've never actually used them myself.
I'd therefore be interested to...
June 28, 2010 at 7:43 am
lbrigham (6/28/2010)
or did someone else already mention this?
:rolleyes:
Aaron N. Cutshall (6/28/2010)
June 28, 2010 at 7:26 am
Viewing 15 posts - 2,746 through 2,760 (of 3,347 total)