将数组传入SQL In条件中

时间：2016-03-18 16:04:11 收藏：0 阅读：236

CREATE TABLE #test
( name VARCHAR(50),
age INT
)
INSERT INTO #test
        ( name, age )
VALUES  ( ‘lily‘, -- name - varchar(50)
          28  -- age - int
          )
INSERT INTO #test
        ( name, age )
VALUES  ( ‘jack‘, -- name - varchar(50)
          28  -- age - int
          )
INSERT INTO #test
        ( name, age )
VALUES  ( ‘snow‘, -- name - varchar(50)
          28  -- age - int
          )
INSERT INTO #test
        ( name, age )
VALUES  ( ‘neal‘, -- name - varchar(50)
          28  -- age - int
          )


DECLARE @NameList VARCHAR(50)=‘‘‘lily‘‘,‘‘jack‘‘,‘‘neal‘‘‘
EXEC (‘SELECT * FROM #test WHERE name IN (‘+@NameList+‘)‘)
PRINT (@NameList)


http://blog.csdn.net/make1828/article/details/39498197

原文：http://www.cnblogs.com/anranstl/p/5292408.html