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 vote152 views1 answer
How to find total working hour in sql
SQL
0 vote132 views1 answer
What are the aggregate function in sql
SQL
31 votes154 views3 answers
Sql count
SQL
0 vote145 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
2 votes140 views2 answers
Oracle multiple insert
SQL
1 vote145 views1 answer
Stored procedure return value
SQL
40 votes205 views6 answers
Update table mysql
SQL
2 votes156 views1 answer
Create delete procedure mysql
SQL
10 votes146 views3 answers
How to fetch first 5 characters in sql
SQL
-2 votes137 views3 answers
Oracle tablespace usage
SQL