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)
-
▼
March
(23)
- Filling random passwords - Set based approach
- SQLBits IV
- SQL Solutions OLAP Heartbeat and OLAP Performance ...
- Splitting delimited data to columns - Set based ap...
- Return TOP N rows
- Export to EXCEL with column names
- SQL_VARIANT_PROPERTY function
- Time Calculation on Numbers
- Row_number() Function with no specific order
- Script of DDL triggers
- NULL on joined columns
- Happy New Year
- Compatibility Level of a database
- Find Alphanumerals only
- SQL_VARIANT datatype and behaviour changes
- Beware of the Usage of SET ROWCOUNT
- Which columns uniquely identify a row?
- Behavior Changes to Database Engine Features in SQ...
- BI Survey 8
- Query behaviour when you cross the LowMemoryLimit
- Analysis Services and the System File Cache
- Updated Wiki: Home
- Updated Wiki: Home
-
▼
March
(23)
Post a Comment