An interview puzzle: write one UPDATE that flips male to female and female to male. Can you swap value of column data without a CASE statement?
SQL SERVER – A Puzzle Part 4 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
Part 4 of my SEQUENCE puzzles uses a DECIMAL sequence that counts down by 1 and cycles. Can you guess the next value SQL Server 2012 returns?
SQL SERVER – A Puzzle Part 3 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
My SEQUENCE puzzle part 3 involves some service related steps, so run it only on a test machine, never on production. Can you guess the next value?
SQL SERVER – A Puzzle Part 2 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
Part 2 of fun with SEQUENCE: the same script as before, but without MINVALUE. Now guess the next value SQL Server 2012 returns after the cycle.
SQL SERVER – A Puzzle – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
A fun puzzle on SEQUENCE in SQL Server 2012: a sequence starts at 3 and cycles with a maximum of 5. Can you guess the next value it returns?
SQL SERVER – A Puzzle – Fun with NULL – Fix Error 8117
NULL is fun to ask about in interviews, since every answer I get is different. A short puzzle on NULL that raises Error 8117, and how to fix it.
SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST
A Saturday fun puzzle with DATETIME2 and CAST in SQL Server 2012. Run each script one at a time, guess the output, and learn something new.