SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » T-SQL » sql (RSS)

Browse by Tags

  • 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 all select 345 union all select getdate () union...
    Posted to Madhivanan (Weblog) by Madhivanan on Fri, Feb 20 2009
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems