Collections:
List of Data Types in SQL Server Transact-SQL
How many data types supported in SQL Server Transact-SQL? I want a list of all data types.
✍: FYIcenter.com
Here is a list of all Transact-SQL data types divided into 6 categories:
1. Exact Number - Used to hold numeric values truncated to a specific precision and scale.
2. Approximate Number - Used to hold numeric values with floating scales.
3. Data and Time - Used to hold dates and times.
4. Single-Byte Character Strings - Used to hold ASCII character strings.
5. Unicode Character String - Used to hold Unicode character strings.
6. Binary String - Used to hold binary strings.
7. Others - Used to hold other special types of data.
By the way, Transact-SQL supports the same list of data types as the SQL Server table columns.
For more information, see "Data Types (Transact-SQL)" at Microsoft Website.
⇒ Exact Numeric Data Types in SQL Server Transact-SQL
⇐ What Is Variable in SQL Server Transact-SQL
2017-04-22, 1545🔥, 0💬
Popular Posts:
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...