DECLARE @Data NVARCHAR(max)
DEALLOCATE data_cursor

*/
FETCH NEXT FROM data_cursor INTO @dataItem
DECLARE data_cursor CURSOR FOR (SELECT * FROM split(@Data,';'))
CLOSE data_cursor
DECLARE @dataItem NVARCHAR(100)
WHILE @@FETCH_STATUS=0

BEGIN
DECLARE @Name NVARCHAR(50)
*/
FETCH NEXT FROM dataItem_cursor INTO @Id

BEGIN
DECLARE @Id INT
FETCH NEXT FROM dataItem_cursor INTO @Name

DECLARE @Temp TABLE
DECLARE @Name NVARCHAR(50)
INSERT INTO @Temp SELECT (SELECT * FROM split(@Data,';'))
SET @Results=@Results+@Name+','

CLOSE dataItem_cursor
SET @Data='1,tanw,2,keenboy' --Id,Name
/*

SELECT TOP 1 @Id=Id,@Name=Name from @Temp
DEALLOCATE dataItem_cursor

复制代码 代码如下:

在这里做逻辑处理，插入或更新操作 ...
DECLARE @Results NVARCHAR(MAX) SET @Results=''

复制代码 代码如下:

DECLARE dataItem_cursor CURSOR FOR (SELECT * FROM split(@dataItem,','))

OPEN dataItem_cursor
在这里做逻辑处理，插入或更新操作 ...
)
WHILE EXISTS(SELECT * FROM @Temp)
(
OPEN data_cursor

END
/*
2.While方式
SELECT @Results
DELETE FROM @Temp where [id] = @Id
DECLARE @Id INT
SET @Data='tanw,keenboy' --Id,Name
END
DECLARE @Data NVARCHAR(max)
Id INT IDENTITY(1,1),
Name NVARCHAR(50)