Mega Code Archive

 

Categories / MSSQL Tutorial / Data Types

 

Sql_variant type column

26>  CREATE TABLE variant2 27> (a sql_variant, b sql_variant ) 28> GO 1> INSERT INTO variant2 2>     VALUES (CAST (111 as int), CAST(222 as money )) 3> GO (1 rows affected) 1> INSERT INTO variant2 2>     VALUES (CAST (333 as int), CAST(444 as char(3) )) 3> GO (1 rows affected) 1> 2> SELECT * 3> FROM variant2 4> WHERE a > b 5> 6> GO a  b --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - 333  444 (1 rows affected) 1> 2> SELECT * 3> FROM variant2 4> WHERE a < b 5> GO a  b --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - 111  222 (1 rows affected) 1> 2> drop table variant2; 3> GO 1>