declare @sql varchar(8000),@str varchar(100)
set @str='123,234,345,456'
set @sql='select * from (select '+replace(@str,',',' as a union all select ')
+') a'
print @sql
exec(@sql)
set @str='123,234,345,456'
set @sql='select * from (select '+replace(@str,',',' as a union all select ')
+') a'
print @sql
exec(@sql)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货