Viewing 15 posts - 166 through 180 (of 848 total)
Had no idea as I do not do a lot with logins. Good question. Definitely learned something today!
March 26, 2014 at 4:05 pm
Fun question. Thanks Andy.
I did get to finish my lunch but since I am a workaholic I was already driving back to the office with my burrito bowl to...
March 20, 2014 at 12:10 pm
Agreeing with the majority here, answer B seemed more correct. Thanks for the question though!
March 19, 2014 at 11:09 am
Very nice. I think this one can be related to globally.
March 19, 2014 at 11:00 am
Stewart "Arturius" Campbell (3/18/2014)
crussell-931424 (3/18/2014)
But what happens when you fill those varchar fields with data?the insert / update will fail...
Actually, I am not seeing a failure when the varchar columns...
March 18, 2014 at 1:27 pm
I only got this right because I actaully read the question and answers out loud to make sure I got those double negatives correct. Good question. I am glad the...
March 11, 2014 at 12:55 pm
CGSJohnson (3/5/2014)
They're actually called features! 😀
+1
March 5, 2014 at 3:09 pm
A good example of how important attention to detail is. Thanks Anoo.
March 4, 2014 at 10:38 am
Carlo Romagnano (3/2/2014)
Igor Micev (3/2/2014)
Question is identical with that of 2014/02/26.The answer is also identical.
Am I missing something?
+1
But where is EXCEPT-1?
Why, if the qotd is identical to that of 2014/02/26,...
March 2, 2014 at 11:34 pm
I always use Exists and Not Exists instead of Intersect and Except. I have never seen Intersect used in any DB that I have worked on.
February 26, 2014 at 9:17 am
We've implemented a couple CLR functions for string concatenation, string splitting and parsing and that is it. They are rarely used. We don't see a great need to use CLR.
February 21, 2014 at 6:55 pm
Viewing 15 posts - 166 through 180 (of 848 total)