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

-1 vote330 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote259 views1 answer
Sqlalchemy existing database
SQL
2 votes306 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote331 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
-1 vote283 views2 answers
Sql query examples
SQL
12 votes315 views1 answer
Docker mysql random root password
SQL
6 votes341 views4 answers
Mysql update set
SQL
0 vote324 views1 answer
Mysql join column order By and group By
SQL
0 vote332 views1 answer
Shrink database file in sql server
SQL
1 vote326 views3 answers
How to filter repeated same result using sql query
SQL