When you use sql_variant datatype in sql server 2000 , and add data to a table using union all, it will work though datatype of data differs from each other declare @test table ( variant_column sql_variant ) insert into @test select 'test' union...(read more)
A
New
Internet
Library: Add Your Website/Blog
or Suggest A Website/Blog to our Free Web Directory
http://anil.myfunda.net.
Its very simple, free and SEO Friendly. Submit Now....
Its very simple, free and SEO Friendly. Submit Now....
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2009
(102)
-
▼
February
(15)
- SQL_VARIANT datatype and behaviour changes
- SQL Server Conference in Italy
- Madison and SSAS?
- Updated Wiki: HowToUseCodePlex
- New Comment on "HowToUseCodePlex"
- Find Alphanumerals only
- Implementing Real Analysis Services DrillDown in a...
- SQLBits IV Registration Open!
- PASS European Conference 2009 and Analysis Service...
- SQLBits IV voting now open
- Speeding up the Query Parameters Dialog in the SSR...
- Fact dimension relationships
- Updated Wiki: Home
- Updated Wiki: Home
- Updated Wiki: Home
-
▼
February
(15)
Post a Comment