Viewing 15 posts - 466 through 480 (of 551 total)
Good one, thank you for the question.
For me when i saw the resultset, it was 2,0. but it gave error message due to not null constraint, so I chose the...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
October 6, 2012 at 4:43 am
very interesting one, 🙂 thank you for the question.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
October 2, 2012 at 1:55 am
Simply nice one. 🙂
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
October 1, 2012 at 10:10 am
😛 (my mining skills were too weak to pick the correct answers. after reading the explanation i came to know it was never designed to go such deep.......:hehe:)
Nice question, thank...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 28, 2012 at 8:58 am
🙂 (...all that I had)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 27, 2012 at 3:55 am
Nice and easy one after a long time, thank you for the question Amit-ji. (this is the only qtod which i tool less than 2 secs to choose the answer...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 25, 2012 at 11:23 pm
Interesting one.:-) thank you Lokesh-ji
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 25, 2012 at 1:36 am
Nice question 🙂
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 23, 2012 at 1:36 am
vk-kirov (9/21/2012)
...(although I'd 'guessed' the author's thoughts and answered 'sp_who2' :hehe: )
OR probably author can edit the question and add" and writes" in the appropriate place. (only if this...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 21, 2012 at 12:28 am
rVadim (9/20/2012)
I answered "Non of the above". I thought DiskIO in sp_Who2 means reads and writes combined, not just reads as question asks. Am I wrong?
+1
(I got the answer right...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 21, 2012 at 12:22 am
Good one :), thank you for the question.
(For me the "Classification Function" made be to doubt my knowledge which I gained from previous 14 hours where for the first time...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 20, 2012 at 12:50 am
Hugo Kornelis (9/19/2012)
However, the official correct answer is still a bit questionable. The result of a...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 19, 2012 at 1:55 am
Evgeny Garaev (9/18/2012)
create table #Test (ID int primary...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 18, 2012 at 11:44 pm
Awesome. 🙂 thank you for the interesting question
Got this wrong too, well I have seen this feature but never used. I need to work on this a lot now to...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 18, 2012 at 11:31 pm
Awesome Philip, thank you 🙂 for the details.
philip.cullingworth (9/18/2012)
The results you are getting are due to you only specifying the collation on the where clause.
The query is selecting rows 1,...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 18, 2012 at 1:58 am
Viewing 15 posts - 466 through 480 (of 551 total)