tsql - 将整数列表分配给@var

Question

我可以:

declare @idOrder int
set @idOrder = 21319

我想要:

declare @idOrder int
set @idOrder = (21319, 21320)

用于“WHERE”子句使用 IN 运算符的一系列语句

delete Orders
where idOrder in @idOrder

代替

delete Orders
where idOrder in (21319, 21320)

Answer 1

只要是 int，你就不能这样做，因为这不是该数据类型的有效值。可以采用多个整数的数据类型是 table

declare @idOrder table (id int)

insert into @idOrder values(21319)
insert into @idOrder values(21320)

delete from Orders where idOrder in (select id from @idOrder)