← Back to Posts

STRING_SPLIT SQL-SERVER

👤 علی ذوالفقار 📅 1403/03/16 09:05:25 👁️ 140 views
	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 to Posts