- # 字符串 Split
- declare @sql1 varchar(1000)
- set @sql1 = 'select field=''' + replace('1,23,456,789',',','''union all select''')+''''
- exec(@p_sql)
- # 结果集用作条件
- declare @sql2 varchar(1000)
- set @sql2 = 'select field1,field2,field3 from table_name where field1 in ('+@p_sql+')'
- exec(@p_sql)
来源: http://www.bubuko.com/infodetail-3818225.html