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.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: The sql_variant Datatype
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 02/18/2002 :  20:38:39  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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 - 02/19/2002 :  14:10:27  Show Profile  Visit jcelko's Homepage  Reply with Quote
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 - 02/19/2002 :  18:54:55  Show Profile  Visit robvolk's Homepage  Reply with Quote
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 - 02/19/2002 :  19:13:58  Show Profile  Reply with Quote
Don't give him a heart attack Rob!


Tomorrow is the same day as Today was the day before.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000