--1
declare @stcdList varchar(200)
set @stcdList='50100100,50103100,50103000'
declare @sql varchar(8000)
set @sql='select stcd from A where stcd in ('+@stcdList+')'
exec(@sql)
--2說詳細點
declare @stcdList varchar(200)
set @stcdList='50100100,50103100,50103000'
declare @sql varchar(8000)
set @sql='select stcd from A where stcd in ('+@stcdList+')'
exec(@sql)
--2說詳細點
declare @stcdList varchar(200)
set @stcdList='50100100,50103100,50103000'
declare @sql varchar(8000)
set @sql='select distinct stcd from ST_PPTN_R where stcd in ('+@stcdList+')'
exec(@sql)
這樣 in('50100100','50103100','50103000' )可以直接 in(50100100,50103100,50103000)
set @stcdList='50100100,50103100,50103000'
set @stcdList= replace(@stcdList,',',''',''')
declare @sql varchar(8000)
set @sql='select stcd from A where stcd in ('''+@stcdList+''')'
exec(@sql)