SentryOne Team Blog (blogs.sentryone.com)

Tag : Transact-SQL

A SQL _VARIANT Use Case (No Pun Intended)

Aaron Bertrand (@AaronBertrand) uses a T-SQL Tuesday theme to demonstrate a use case for the SQL_VARIANT data type that you may not have considered: Conditional ORDER BY.

Aaron Bertrand : Dirty Secrets of the CASE Expression

Aaron Bertrand (@AaronBertrand) of SQL Sentry takes a look at some unexpected behavior with the CASE expression and some of its derivatives.