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 vote113 views1 answer
T-SQL Alter the column data type
SQL
0 vote104 views1 answer
Lister les index d'une table oracle
SQL
0 vote115 views2 answers
Csv into data postgres
SQL
0 vote118 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote118 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote119 views1 answer
Mysql concatenate select results
SQL
0 vote119 views1 answer
Mariadb mysql root access denied
SQL
2 votes131 views1 answer
Mariadb json select
SQL
2 votes112 views1 answer
Sql like variable
SQL
0 vote130 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL