Viewing 15 posts - 76 through 90 (of 515 total)
Took some time to interpret the question, but eventually got that correct. The key to answer is to visualize how the data gets stored in table variable. Like for the...
May 30, 2013 at 12:55 am
Interesting question Steve. I had no idea about this, except the connection of VARBINARY and FILESTREAM. Luckily was able to guess the correct answer 🙂
May 28, 2013 at 9:38 pm
Easy one for the day. But I rarely use this function. Thanks for reminding the basics Mike 🙂
May 23, 2013 at 6:13 am
Danny Ocean (5/21/2013)
i have no idea about this topic. I just guessed and got it right.Thanks for question 🙂
+1
I was little confused between msdb and master DB. Some how marked...
May 22, 2013 at 1:09 am
I found Today's question relatively easier than yesterday. 🙂
May 15, 2013 at 12:39 am
Lucky enough to find the anomaly instead of getting into the trap of "BETWEEN (high) AND (low)" which should be otherwise 🙂
May 13, 2013 at 11:05 pm
Stewart "Arturius" Campbell (5/9/2013)
God question, thanks - one of the reasons why i prefer to use JOINs over subqueries.
+1
May 9, 2013 at 4:18 am
kapil_kk (5/6/2013)
Danny Ocean (5/5/2013)
I think author did mention it clearly that execute all statement in a single batch.Due to that i lose my points..:doze:
Me too lose the points 🙁
+1 🙁
May 6, 2013 at 12:34 am
I too rushed (over read "batch") and got the question wrong! 🙁
May 6, 2013 at 12:32 am
Good one!
I remember posting a similar Qotd last year. Here is the link: http://www.sqlservercentral.com/questions/T-SQL/93222/[/url]
May 4, 2013 at 3:05 am
Thanks for the question Vinay.
An easy one for the day. It's always good to refresh our basics 🙂
May 2, 2013 at 5:46 am
Viewing 15 posts - 76 through 90 (of 515 total)