The SQL Variant Types

• Steve Jones - SSC Editor

  SSC Guru

  Points: 729696

  More actions

  November 18, 2022 at 12:00 am

  #4106967

  Comments posted to this topic are about the item The SQL Variant Types

  Follow me on Twitter: http://www.twitter.com/way0utwest
  Forum Etiquette: How to post data/code on a forum to get the best help
  My Blog: www.voiceofthedba.com

• Carlo Romagnano

  SSC-Insane

  Points: 22349

  More actions

  November 18, 2022 at 8:00 am

  #4114711

  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])