Viewing 15 posts - 391 through 405 (of 552 total)
honza.mf (3/11/2013)
wolfkillj (3/11/2013)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 11, 2013 at 10:37 am
Thank you for the question. I got it right as I knew this. 🙂
(and I was expecting to see this "2050-01-27" as one of the answers for value-2)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 11, 2013 at 3:27 am
well....i did it again......
knowing the declaration without the size will default to 1 and at the time of cast/convert it defaults to 30.... and... me being dumbest of all the...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 6, 2013 at 12:22 am
Awesome put. Thank for posting very neatly.
(i kind of had a catch that after disabling and the next statement it rebuilds.... so i assumed it might activate the index again......
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 5, 2013 at 4:59 am
ashwani24 (2/28/2013)
I guess answer is Yes as it compiled and executed successfully but sql server restricts for nested looping to 32 level so it fails after execution of 32 times.
no...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 1, 2013 at 1:09 am
p.govindaraj (3/1/2013)
Yes, It will create infinite loop but it will end with maximum nesting level on 32
No it is not infinite loop, as you said it executes 32 times -...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 1, 2013 at 1:05 am
Simply nice, thank you for posting.
got it wrong, i selected "yes", i cancelled the page transaction but it was too late... the answer got submitted.
and couple of concerns
1. The batch...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 1, 2013 at 12:52 am
demonfox (2/28/2013)
yes.. and I think , it would be same as this one
...also significant improvement on the EP.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 28, 2013 at 12:29 am
Good one. :), thank you for posting. (very cute logic...)
i manually iterated the update in mind and 5 OK, 6 OK 7 OK and then for last entry 4 i...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 27, 2013 at 11:08 pm
L' Eomot Inversé (2/27/2013)
However, the default isn't Latin1_General_CI_AI, it's case insensitive. But it's accent sensitive - CI_AS
actually... mine does. I am using the below version
Microsoft SQL Server...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 27, 2013 at 7:46 am
demonfox (2/27/2013)
Kingston Dhasian (2/26/2013)
handkot (2/26/2013)
the answer is ambiguous and depends from collationsI agree somewhat
The answers will change if the database collation is case sensitive
But, overall a very good question.
Well, I...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 27, 2013 at 1:13 am
Very interesting question, did not know until now... and I answered all correct with just mental work 🙂 and I can feel my confidence is somewhat kicking in back..
(note :...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 27, 2013 at 1:03 am
Dineshbabu (2/21/2013)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 21, 2013 at 3:28 am
demonfox (2/18/2013)
zerko (2/18/2013)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 19, 2013 at 12:54 am
Interesting question, thank you for posting.
Did not tried this before, so had really no idea , but bit search on offline BOL, was able to guess that opt-3 may be...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 18, 2013 at 3:28 am
Viewing 15 posts - 391 through 405 (of 552 total)