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, 1639🔥, 0💬
Popular Posts:
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you nee...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...