TOPIC

磷光与烟火逆流

一个敲代码的程序猿

SQLServer 实现字符串Split

# 字符串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)
posted @   Jacobyang  阅读(67)  评论(0编辑  收藏  举报
点击右上角即可分享
微信分享提示