Viewing 15 posts - 1 through 15 (of 121 total)
Nice question, Steve. However, it won't work if the players are playing Rock, Paper, Scissors, Lizard, Spock. 🙂
March 24, 2016 at 11:05 am
Hugo Kornelis (3/5/2016)
I wonder why int to varchar was special.
I am sure that sometime, somewhere deep in the dark and muddy past of SQL Server (probably back in the...
March 24, 2016 at 7:58 am
Nice question, Steve. Thanks!
March 10, 2016 at 7:43 am
Fascinating question, as always, Hugo. Thanks!
December 18, 2015 at 8:13 am
Thanks for the excellent questions, Hugo. I look forward to your next ones!
November 12, 2015 at 7:26 am
Excellent question, Hugo, thanks. I got the first three right, but missed the performance one because I though that perhaps with NOLOCK, the system would choose a slightly sub-optimal query...
November 10, 2015 at 8:13 am
Excellent question, Stewart, thanks.
My only (minor) criticism is that you should have had more than one option for the output from "SELECT * FROM abc;", such as "returns columns a,...
November 6, 2015 at 7:37 am
Thanks for the great question, Steve (even if you did flub the answer).
November 5, 2015 at 8:18 am
Excellent question, Paul. I read the answers and thought that the second and third answers couldn't possibly be right. Ha! I should have been more suspicious. I would probably be...
November 3, 2015 at 4:37 pm
When I try this in Sybase ASE, it returns this error message:
ERROR: Implicit conversion from datatype 'VARCHAR' to 'NUMERIC'
is not allowed. Use the CONVERT function to run this query....
October 30, 2015 at 7:55 am
Ben, thanks for the question. I thought the "correct" answer looked a little too obvious, but I chose it anyway, and thought as I clicked "Submit", "It's probably the overflow...
October 30, 2015 at 7:49 am
Interesting question, Junior. Thanks!
October 21, 2015 at 8:04 am
Thanks for the good question, Steve.
Welcome to the forum, Daleen!
October 20, 2015 at 6:47 am
Thanks for the easy question, Steve.
October 19, 2015 at 8:05 am
Thanks for the excellent question, Andy. The MS documentation seems to be pretty poor on non_transacted_access (I know, shocking, isn't it?): it just shows the possible values and how to...
October 16, 2015 at 1:34 pm