Multiple choice technology databases

SQL_VARIEANT datatype column can be any datatype except?

  1. TEXT

  2. IMAGE

  3. FLOAT

  4. 1) and 2)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SQL_VARIANT can store most SQL Server data types except large object types like text, ntext, image, timestamp, and the MAX variants (varchar(max), nvarchar(max), varbinary(max), xml). TEXT and IMAGE are legacy large object types that SQL_VARIANT cannot handle. FLOAT is valid within SQL_VARIANT. The question has a typo (VARIEANT should be VARIANT).

Keep practicing — related questions