Browse by Tags

All Tags » sql (RSS)

SQL_VARIANT datatype and behaviour changes

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...
Posted by Madhivanan | 1 comment(s)
Filed under: , ,