10 reasons to explicitly convert SQL Server data types
SQL Server converts data types in two ways -- the way it wants to and the way you tell it to. Most implicit conversions work the way you expect. It's those surprise conversions that cause trouble. Unless you know exactly how SQL Server converts a data type, it's a good idea to explicitly convert it. Susan Harkins demonstrates 10 situations where you'll want to control the conversion outcome.
This download is also available as an entry in our 10 Things blog>.