TSQL – Part 1(c) – Data Types

  • Transact-SQL supports a wide range of data types, which can be broadly categorized as exact numericapproximate numericcharacterdate/timebinary, 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s