if object_id('tempdb..#') is not null drop table #
SELECT TOP 10 id = IDENTITY(int, 1, 1) INTO # FROM syscolumns
declare @str varchar(100)
set @str='aaa,bbb,ccc'
select substring(@str , id , charindex(',' , @str + ',' , id)- id) as vs
from #
where substring(',' + @str, id , 1) = ','
/////////////////////////////½á¹û
vs
---
aaa
bbb
ccc
declare @str varchar(100)
set @str='aaa,bbb,ccc'
select id,charindex(',' , @str + ',' , id)- id,substring(@str, id , charindex(',' , @str + ',' , id)- id) as vs
from #
where substring(',' + @str, id , 1) = ','
id vs
----- ----- -------
1 3 aaa
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载