Community

Subtleties of Data-Type Precedence

(Brian Moran) A reader sent in a T-SQL query because it didn’t work as he expected. He was unable to concatenate 0 with the WHEN ‘1’ branch of the CASE statement. The T-SQL code is supposed to explicitly convert the integer value ‘2004-09-24’ to a char data type, but the result remains an integer va

Read More - Register for Free Membership