TSQL convert csv to table

CREATE FUNCTION [dbo].[CSV2TABLE] (@InStr nvarchar(MAX))
RETURNS @TempTab TABLE
   (id nvarchar(MAX) NOT NULL)
AS
BEGIN
    
	SET @InStr = REPLACE(@InStr + ',', ',,', ',')
	DECLARE @SP INT
	DECLARE @VALUE nvarchar(MAX)

	WHILE PATINDEX('%,%', @INSTR ) <> 0 
	BEGIN
  	 SELECT  @SP = PATINDEX('%,%',@INSTR)
  	 SELECT  @VALUE = LEFT(@INSTR , @SP - 1)
  	 SELECT  @INSTR = STUFF(@INSTR, 1, @SP, '')
   	INSERT INTO @TempTab(id) VALUES (@VALUE)
END
	RETURN
END

Similar codes

0 vote363 views3 answers
Duplicate row mysql
SQL
0 vote365 views1 answer
Mysql url data type
SQL
0 vote348 views1 answer
Mysql workbench view
SQL
0 vote337 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote331 views1 answer
Ms sql unique
SQL
0 vote339 views1 answer
Select max salary from each department in sql
SQL
0 vote349 views2 answers
How to check if sqlite table exists in nodejs
SQL
1 vote355 views1 answer
Can not connect to mysql server
SQL
-1 vote345 views2 answers
On update cascade
SQL
0 vote351 views1 answer
Mysql conf.d exampel
SQL