Converting sql_variant Type to Text???

• art

  SSC Journeyman

  Points: 98

  More actions

  March 28, 2008 at 7:26 am

  #183920

  We have a table with two sql_variant type fields that need to be converted to either text or image fields to prevent the data from exceeding the overall record length.

  Any thoughts on how this may be accomplished other than writing a C# program to do a read write?

  Thanks in advance.

  art

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  March 28, 2008 at 9:51 am

  #795300

  Look at the [font="System"]SQL_VARIANT_PROPERTY[/font] function.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]