Viewing 5 posts - 31 through 35 (of 35 total)
Given the answer options, I agree that the sp_foreachtable option was the only correct one.
I agree with that completely, but it is not quite precise because triggers created on VIEW...
July 1, 2010 at 5:16 am
Good tricky one...thank you
It would be even trickier if the first answer was 5.
Hrvoje
June 30, 2010 at 2:07 am
da-zero (4/28/2010)
That will teach you using Safari 😛
nice one da-zero 🙂 let's open a new item at connect: IE for iPhone:-D
I am actually glad I messed up for the...
April 28, 2010 at 1:21 am
Well, here's a new one: I got it wrong - answered 0 - because of the way safary on iPhone renders the code. I was Like WTF way down 4...
April 27, 2010 at 4:42 pm
There is no implicit conversion from integer to UID and your sp is trying to do just that.
See uniqueidentifier:
http://www.sqlservercentral.com/questions/T-SQL/66113/
and answer explanation.
Another method was suggested in the discussion...
March 30, 2010 at 6:44 pm
Viewing 5 posts - 31 through 35 (of 35 total)