SQL SQL variants
SQL
Download (.zip)
USE pubs GO IF EXISTS (SELECT * FROM sysobjects WHERE name = 'variant2' AND type = 'u') DROP TABLE variant2 GO CREATE TABLE variant2 (a sql_variant, b sql_variant ) GO INSERT INTO variant2 VALUES (CAST (111 as int), CAST(222 as money )) GO INSERT INTO variant2 VALUES (CAST (333 as int), CAST(444 as char(3) )) GO
SELECT * FROM variant2 WHERE a > b GO SELECT * FROM variant2 WHERE a < b GO
|