STRING_SPLIT SQL-SERVER
علی ذوالفقار
1403/03/16 09:05:25 (109)
Declare @inputstring as varchar(25) = 'Microsoft,sql,server,2016' ;
select value from STRING_SPLIT( @inputstring ,',')
----------------------------------
Item_tagList : TABLE
----------------------------------
ItemId | Item | Tag
----------------------------------
select ITL.Item , Value as ItemTag from Item_tagList ITL
cross apply string_split(tag,',')