Transact-SQL Data Types
Data types define what type of data the table cell will hold.
Data types
Data type category | Data type |
---|---|
Exact numerics | bigint, numeric, bit, smallint, decimal, smallmoney, int, tinyint, money |
Approximate numerics | float, real |
Date and time | date, datetimeoffset, datetime2, smalldatetime, datetime, time |
Character strings | char, varchar, text |
Unicode character strings | nchar, nvarchar, ntext |
Binary strings | binary, varbinary, image |
Other data types | cursor, rowversion, hierarchyid, uniqueidentifier, sql_variant, table |
Refer the MS article on Data types (Transact-SQL) for a complete list and their definitions.
Next Steps
Run the T-SQL queries to interact with MS SQL Server.
This tutorial demonstrates all the examples in the query editor available in MS SQL Server Management Studio (SSMS) on a Windows2019 Server.
You can execute the example T-SQL queries in both Linux and Mac OS using the
sqlcmd
utility running on your OS or on a Docker container; depending upon the type of MS SQL Server installation.
Did you find this page helpful?
Start with GraphQL on Hasura for Free
Build apps and APIs 10x faster
Built-in authorization and caching
8x more performant than hand-rolled APIs

