SQL SQL variants
SQL variants
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