Tách chuỗi với T-SQL

Đoạn mã sau đây chỉ cho bạn cách tách chuỗi với dấu phảy phân cách bằng việc sử dụng hàm CharINDEX trong Microsoft SQL Server. declare @fieldName as nvarchar(100) declare @concat as nvarchar(100) declare @pos as int set @fieldName = 'field1,field2...

Đoạn mã sau đây chỉ cho bạn cách tách chuỗi với dấu phảy phân cách bằng việc sử dụng hàm CharINDEX trong Microsoft SQL Server.

view plainprint?

1. declare @fieldName as nvarchar(100)
2. declare @concat as nvarchar(100)
3. declare @pos as int
4. set @fieldName = 'field1,field2,field3,field4,field5,field6,field7,field1,field2,field3,field4,field5,field6,field7'
5. declare @flag as int
6. if (@fieldName is null or @fieldName='')
7. set @flag=0
8. else
9. set @flag=1
10. while (@flag=1)
11. Begin
12. set @pos = charINDEX(',',@fieldName)
13. if (@pos=0)
14. Begin
15. select @concat = @fieldName
16. set @fieldName=''
17. End
18. else
19. Begin
20. select @concat = substring(@fieldName,0,@pos)
21. End
23. print(@concat)
24. set @fieldName = substring(@fieldName,@pos+1,len(@fieldName))
25. if (@fieldName is null or @fieldName='')
26. set @flag=0

declare @fieldName as nvarchar(100) declare @concat as nvarchar(100) declare @pos as int set @fieldName = 'field1,field2,field3,field4,field5,field6,field7,field1,field2,field3,field4,field5,field6,field7' declare @flag as int if (@fieldName is null or @fieldName='') set @flag=0 else set @flag=1 while (@flag=1) Begin set @pos = charINDEX(',',@fieldName) if (@pos=0) Begin select @concat = @fieldName set @fieldName='' End else Begin select @concat = substring(@fieldName,0,@pos) End print(@concat) set @fieldName = substring(@fieldName,@pos+1,len(@fieldName)) if (@fieldName is null or @fieldName='') set @flag=0