The SQL Variant Types

Question

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Carlo Romagnano SSC-Insane Points: 22772 More actions · Answer 1

Good catch!

It is Interesting that NULL never has a BaseType, also if you cast it to a defined type (e.g. INT).

SELECT *
,LEN(V.a)
,dataLENgth(V.a)
,SQL_VARIANT_PROPERTY(V.a, 'BaseType')
 FROM (VALUES
 (N'1')
,('2')
,('3')
,(NULL)
) AS V([a])

Cookies on SQLServerCentral