Nice question, Steve. However, it won't work if the players are playing Rock, Paper, Scissors, Lizard, Spock. 🙂

Hugo Kornelis (3/5/2016)

I am sure that sometime, somewhere deep in the dark and muddy past of SQL Server (probably back in the...

Nice question, Steve. Thanks!

Fascinating question, as always, Hugo. Thanks!

Thanks for the excellent questions, Hugo. I look forward to your next ones!

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...

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,...

Thanks for the great question, Steve (even if you did flub the answer).

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...

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....

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...

Interesting question, Junior. Thanks!

Thanks for the good question, Steve.

Welcome to the forum, Daleen!

Thanks for the easy question, Steve.

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...