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, 1546🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...