Not on Mac? Download TablePlus for Windows. And it’s free to use for as long as you need it to. Need a good GUI Tool for MS SQL Server? Try TablePlus, a modern, native tool for multiple databases including SQL Server, MySQL, PostgreSQL, SQLite, etc. Stores a reference to a cursor used for database operations Stores a globally unique identifier (GUID) A brutal way to do this is: replace (convert. Stores up to 8,000 bytes of data of various data types, except text, ntext, and timestamp The Microsoft SQL Server DB engine supports Unicode by the built-in NCHAR, NVARCHAR, and NTEXT data types. Each table may have only one timestamp variable. The timestamp value is based upon an internal clock and does not correspond to real time. Stores a unique number that gets updated every time a row gets created or modified. Time zone offset range from -14:00 to +14:00. Variable width character string with n is the number of characters to store. String types Data typeįixed width character string with n is the number of characters to store.

Here is the full list of all supported data types in Microsoft SQL Server, including string, number, date, and some other types.

Sql server data types