将整数列表分配给@var [英] Assign a list of integers to an @var

问题描述

我可以:

declare @idOrder int
set @idOrder = 21319

我想要:

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

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

for use in a series of statements where the 'WHERE' clause uses the IN operator

delete Orders
where idOrder in @idOrder

代替

delete Orders
where idOrder in (21319, 21320)

推荐答案

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

You can't do that as long as it's an int, as that's not a valid value for that datatype. A datatype that could take several integers is a 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)

这篇关于将整数列表分配给@var的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！