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,',')


       
Back