Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: The sql_variant Datatype

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2002-02-18 : 20:38:39
Microsoft introduced the sql_variant in SQL Server 2000. You can use the sql_variant to store data of an unspecified or inconsistant type. Or to store data of almost any SQL Server datatype.

Article Link.

Esteemed SQL Purist

547 Posts

Posted - 2002-02-19 : 14:10:27
Is there a way to turn this damn thing and preserve normalization, standards, portable code, maintainable code, etc.?

This looks like the nightmare of an idiot OO programmer who does not understand that SQL is a strongly typed language.

Joe Celko, SQL Guru
Go to Top of Page

Most Valuable Yak

15732 Posts

Posted - 2002-02-19 : 18:54:55
Uh, Joe, you'd better close your ears for this one then:


If you hurry, I think you can still get involved with the class action suit, and force MS to drop this "necessary part" of the software and provide a simpler version.

Go to Top of Page

Shed Building SQL Farmer

1591 Posts

Posted - 2002-02-19 : 19:13:58
Don't give him a heart attack Rob!


Tomorrow is the same day as Today was the day before.
Go to Top of Page

- Advertisement -