Viewing 15 posts - 211 through 225 (of 658 total)
Jon Summers (1/3/2014)
Surely the first reseed statement fails because of the use of 'RESEED' as a quoted string and not a keyword?
No, either is allowed. Try it and...
January 3, 2014 at 1:53 am
Hugo Kornelis (12/30/2013)
1. Maybe the IDENTITY code is not nice modularized, but spread out throughout the other code, and changing it is hard and risky. Too...
January 2, 2014 at 2:19 am
Søren (12/16/2013)
a ) is missing in the line (at the end).
I'm most disappointed that there aren't already several pages of identical posts moaning about that and demanding that some points...
December 16, 2013 at 2:49 am
but no points adjustment - I demand back the points I've had forcibly taken from me!
😉
December 6, 2013 at 9:12 am
rmunwin (12/2/2013)
Yes order by is the only truly safe way to do this but there are other methods if I recall. Please set me straight if I'm wrong though.
There are...
December 3, 2013 at 5:44 am
Sadly all those who simply read the explanation and never visit the discussion forum will now go away with false beliefs, and QotD will have worsened understanding rather than increasing...
December 2, 2013 at 3:18 am
Hugo Kornelis (11/9/2013)
On my system NAME and Name are two different columns, because the server collation is case sensitive.
Really surprised nobody else has picked up on this, instead questioning the...
November 18, 2013 at 6:26 am
steve.jacobs (10/30/2013)
I believe in the basics and you would be very surprised as to how many "experienced" DBAs (Logical and\or Physical) I know got this one wrong.
I'm not surprised. How...
October 30, 2013 at 6:55 am
"Exceptions are ..."
So the correct answer is actually "it depends"?
October 25, 2013 at 2:03 am
For me, a better answer is to subtract one from the first day of the next month, as this method will allow the same code to be run on other...
October 24, 2013 at 6:09 am
ronmoses (10/15/2013)
I've yet to discover what numeric type a non-breaking space can be converted to
Most of them I'd have thought, on the basis that in some locales a space is...
October 16, 2013 at 3:48 am
Guessed right, as it would have been a pretty pointless question if the answer had been Yes!
October 9, 2013 at 2:01 am
Putting this in the category "ALTER ROLE" was a bit of a giveaway!
October 3, 2013 at 2:23 am
Jeff Moden (10/1/2013)
Actually, this is going to cause a mess for me when we upgrade from 2005 because NULL is considered to be a DISTINCT value.
I suspect you may be...
October 2, 2013 at 2:12 am
I guessed right, on the basis that very little deprecated functionality ever seems to get removed.
Someone will now post a massive list to prove me wrong 😀
October 2, 2013 at 2:08 am
Viewing 15 posts - 211 through 225 (of 658 total)