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 vote148 views1 answer
Mariadb mysql root access denied
SQL
1 vote139 views1 answer
How to select random rows from table
SQL
0 vote142 views1 answer
Postgresql heritage
SQL
1 vote144 views2 answers
Pl sql case
SQL
0 vote148 views1 answer
Get role postgres
SQL
0 vote177 views1 answer
Mysql 3 months ago
SQL
4 votes152 views4 answers
Check constraint in ms sql
SQL
16 votes149 views4 answers
Mysql import from sql file
SQL
11 votes179 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
14 votes147 views2 answers
Oracle limit rows
SQL