Home
SQL Server / T-SQL Tutorial
Query
Insert Delete Update
Table
Table Join
Data Types
Set Operations
Constraints
Subquery
Aggregate Functions
Date Functions
Math Functions
String Functions
Data Convert Functions
Analytical Functions
Sequence Indentity
View
Index
Cursor
Database
Transact SQL
Procedure Function
Trigger
Transaction
XML
System Functions
System Settings
System Tables Views
User Role
CLR
SQL_VARIANT « Data Types « SQL Server / T-SQL Tutorial
SQL Server / T-SQL Tutorial
Data Types
SQL_VARIANT
5.22.SQL_VARIANT
5.22.1.
sql_variant data type is designed to allow a single variable, column, or parameter to store values in different data types.
5.22.2.
The creation of the table, with a column of the SQL_VARIANT type.
5.22.3.
Insert different type of values into a sql_variant column
5.22.4.
sql_variant type column
5.22.5.
Select case and cast SQL_VARIANT
5.22.6.
Comparing SQL_VARIANTs