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