34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM RSPU
WHERE RSPU.ProductUnit IN ('SC', 'DP', ...)
str = '''SC'', ''DP'', ''SSM'''
declare @str varchar(100)
set @s=''SC', 'DP', 'SSM''
exec('SELECT * FROM RSPU WHERE RSPU.ProductUnit IN('+@s+')')
declare @str varchar(8000)
set @str=
'SELECT * FROM RSPU
WHERE RSPU.ProductUnit IN('+@s+')'
exec(@str)
SELECT * FROM RSPU
WHERE RSPU.ProductUnit IN ('SC', 'DP', 'SSM')