(转自aierong原创技术随笔)sqlserver字符串拆分(split)方法汇总
sqlserver字符串拆分(split)方法汇总 --方法0:动态SQL法declare@svarchar(100),@sqlvarchar(1000)set@s='1,2,3,4,5,6,7,8,9,10'set@sql='selectcol='''+replace(@s,',','''unio...
sqlserver字符串拆分(split)方法汇总 --方法0:动态SQL法declare@svarchar(100),@sqlvarchar(1000)set@s='1,2,3,4,5,6,7,8,9,10'set@sql='selectcol='''+replace(@s,',','''unio...