Viewing 15 posts - 571 through 585 (of 716 total)
Koen Verbeeck (3/4/2014)
Nice question, but the explanation doesn't mention why the order of casting vs order by changes. (because of adding the T alias in the second statement)
+ 1
March 4, 2014 at 1:47 am
I guess there is something wrong with this question as it should be like follows:
SELECT X AS 'Except'
FROM A
EXCEPT
SELECT Y
FROM B
but maybe...
March 3, 2014 at 3:13 am
paul.knibbs (2/26/2014)
I had to go and run this one because I couldn't believe the answer was as simple as it first appeared. Lo and behold, it *was* that simple! :laugh:
I...
March 3, 2014 at 3:07 am
Carlo Romagnano (2/26/2014)
First time I see 99% OK.😀
Now it`s 95% still one of the easiest QotD ever.
March 3, 2014 at 2:41 am
milos.radivojevic (2/26/2014)
dj341 (2/26/2014)
robert.diley (2/26/2014)
(1 row(s) affected)
Msg 8134, Level 16, State 1, Procedure TestProc, Line 6
Divide by zero...
March 3, 2014 at 2:29 am
That was easy 4 me; as I had to use it before.
March 3, 2014 at 1:59 am
SQLRNNR (2/20/2014)
Well, I am dealing with a vendor that has a table named [NULL], numerous columns named [NULL], and I was completely surprised they didn't just name the database [NULL].
😀
February 22, 2014 at 1:13 am
SQLRNNR (2/19/2014)
Definitely an interesting question.It makes you think about the difference between a reserved keyword and just a keyword.
+ 1
February 22, 2014 at 1:10 am
Igor Micev (2/21/2014)
To ensure myself, I read this reference http://technet.microsoft.com/en-us/library/ms186388.aspx and I didn't see any correlation of the model's read_only property to the same for the restoring...
February 22, 2014 at 12:54 am
Igor Micev (2/19/2014)
SQLRNNR (2/19/2014)
Nice question. I wonder how many people have used identity in this way (select into...).
It's used in migrations. For example if you have to migrate users...
February 22, 2014 at 12:40 am
Just a simple & basic info to share: "if you changed the model database to Read-Only mode; then any newly created database will be in Read-Only mode by default".
February 18, 2014 at 1:24 am
Viewing 15 posts - 571 through 585 (of 716 total)