Tuesday, 14 March 2017

What do you understand by "sql_variant" datatype in SQL Server?

sql_variant is a datatype in SQL server,a column of type sql_variant may contain rows of different data types. For example, a column defined as sql_variant can store int, binary, and char value. sql_variant can have a maximum length of 8016 bytes. This includes both the base type information and the base type value. The maximum length of the actual base type value is 8,000 bytes.

WHAT OTHERS ARE READING/RELATED TO THIS:

0 comments:

Post a Comment

Find job here...