我现在有表有三个列。如列名分别为: A B C D E。A是主键。自增列数据如下:
A B C D E
1 2 3 4 5
2 5 6 2 1
3 3 4 2 2现在有问题如下:
如何用一条SQL语句判断某一列的值,即等于X又等于Y. x,y 都是变量。
如C=3 和 C=4 ??
A B C D E
1 2 3 4 5
2 5 6 2 1
3 3 4 2 2现在有问题如下:
如何用一条SQL语句判断某一列的值,即等于X又等于Y. x,y 都是变量。
如C=3 和 C=4 ??
DECLARE @D INT
SELECT * FROM TB WHERE C=@C AND D=@D
DECLARE @D INT
SELECT * FROM TB WHERE C IN(@C ,@D)
declare @d int
set @c=3
set @d=4
select * from tb where c=@c and d=@d
declare @d int
set @c=3
set @d=4
select * from tb where c=@c or c=@d
declare @d int
set @c=3
set @d=4
select * from tb where c=@c
union all
select * from tb where c=@d
INSERT @TB
SELECT 1, 2, 3, 4, 5 UNION ALL
SELECT 2, 5, 6, 2, 1 UNION ALL
SELECT 3, 3, 4, 2, 2DECLARE @X INT, @Y INT
SET @X=3
SET @Y=4IF (SELECT COUNT(DISTINCT C) FROM @TB WHERE C IN (@X,@Y))=2
PRINT N'符合条件'
ELSE
PRINT N'不符合条件'