作者:呵呵 | 来源:互联网 | 2022-12-09 19:31
1> dfundako..:
那是不正确的语法.您不能将两个整数放入变量中,14,15将无法转换为整数.
一个选项是将这些值放入表中:
DECLARE @ints TABLE (val INT)
INSERT INTO @ints (val)
VALUES
(14),
(15)
SELECT * FROM tank_state WHERE dt = @DATE AND tankId IN (SELECT val FROM @ints)