SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

AskSQLTeam
Ask SQLTeam Question

USA
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.

jcelko
Esteemed SQL Purist

USA
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.



--CELKO--
Joe Celko, SQL Guru
Go to Top of Page

robvolk
Most Valuable Yak

USA
15683 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:

SQL.Net!

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

byrmol
Shed Building SQL Farmer

Australia
1591 Posts

Posted - 02/19/2002 :  19:13:58  Show Profile  Reply with Quote
Don't give him a heart attack Rob!

DavidM

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