定义与 IN 运算符 (T-SQL) 一起使用的变量 [英] Define variable to use with IN operator (T-SQL)

问题描述

我有一个使用 IN 运算符的 Transact-SQL 查询.像这样:

I have a Transact-SQL query that uses the IN operator. Something like this:

select * from myTable where myColumn in (1,2,3,4)

有没有办法定义一个变量来保存整个列表(1,2,3,4)"?我应该如何定义它?

Is there a way to define a variable to hold the entire list "(1,2,3,4)"? How should I define it?

declare @myList {data type}
set @myList = (1,2,3,4)
select * from myTable where myColumn in @myList

推荐答案

DECLARE @MyList TABLE (Value INT)
INSERT INTO @MyList VALUES (1)
INSERT INTO @MyList VALUES (2)
INSERT INTO @MyList VALUES (3)
INSERT INTO @MyList VALUES (4)

SELECT *
FROM MyTable
WHERE MyColumn IN (SELECT Value FROM @MyList)

这篇关于定义与 IN 运算符 (T-SQL) 一起使用的变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！