• Transact-SQL supports a wide range of data types, which can be broadly categorized as exact numeric, approximate numeric, character, date/time, binary, and other (which includes specialized data types for handling data such as XML and spatial data).
• Some data types are compatible, and values can be implicitly converted between them. Conversion between other data types requires the use of explicit conversion functions.

 

 

Additional Reading

Review the documentation for Data Types and  Conversion Functions in the Transact-SQL Reference.

 

Note: Microsoft is the owner of the content and video in this blog post.