SQL Server解惑——查询条件IN中能否使用变量
复制IF EXISTS (SELECT 1 FROM sys.objects WHEREname=TESTAND type=U)
BEGIN
DROPTABLE TEST;
END
GO
CREATETABLE TEST ( ID INT, NAMEVARCHAR(16) );
GO
INSERTINTO dbo.TEST
SELECT 1, aUNIONALL
SELECT 2, bUNIONALL
SELECT 3, cUNIONALL
SELECT 4, a,bUNIONALL
SELECT 5, b,cUNIONALL
SELECT 6, b;
GO
1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.
THE END
