Comma Separted Value To Temp Table In Sql Server

DECLARE @Var nvarchar(MAX)

Set @Var ='TABLENAME,TAB'
DECLARE @XML AS XML
DECLARE @Delimiter AS CHAR(1) =','
SET @XML = CAST(('<X>'+REPLACE(@Var,@Delimiter ,'</X><X>')+'</X>') AS XML)
DECLARE @temp TABLE (TABNAME VARCHAR(max))
INSERT INTO @temp
SELECT N.value('.', 'VARCHAR(max)') AS ID FROM @XML.nodes('X') AS T(N)





SELECT * FROM @temp