sqlserver 循环语句（sqlserverfor循环）

科技前沿 • 2025-05-08 11:28 • 阅读 57

大家好，我是讯享网，很高兴认识大家。

 <p>2.游标循环</p>

讯享网

Create table WS_Student
(
[Id] int primary key not null,
[My_Cocode] [int],
[My_SCocode] [int],
[userId] [bigint],
[SetCName] varchar NULL,
[SetEName] varchar NULL,
[SetPcode] varchar NULL,
[SetScode] varchar NULL,
[SetValue] varchar NULL,
[SetSql] varchar NULL,
[Sort] [Int] NULL,
[IsTurnOn] [bit] NULL,
[IsSystem] [bit] NULL,
[Remarks] varchar NULL,
[CreatedUserId] [bigint] NULL,
[CreatedUserName] varchar NULL,
[CreatedTime] [datetime] NULL,
[UpdatedUserId] [bigint] NULL,
[UpdatedUserName] varchar NULL,
[UpdatedTime] [datetime] NULL,
[IsDeleted] [bit] NULL
)
INSERT INTO WS_Student VALUES(1,,,0,‘是否学生’,‘是否学生’,‘WS_Student’,
‘WS_Student_IsStudent’,‘1’,null,1,1,1,‘是否学生’,,‘shil’,GETDATE(),,‘shil’,GETDATE(),0)

这里的 WS_Student2 按照上面方法再创建一个即可

–循环遍历修改记录–
DECLARE @i int;
DECLARE @Name nvarchar(50);
DECLARE @id int;
SET @i=1;
declare WS_Student_cursor cursor
for(SELECT userId,SetCName from WS_Student2)
open WS_Student_cursor
fetch next from WS_Student_cursor into @id ,@Name
while @@FETCH_STATUS=0
BEGIN

INSERT INTO WS_Student VALUES((userId,,,0,‘是否学生2’,‘是否学生2’,‘WS_Student’,
‘WS_Student_IsStudent2’,‘1’,null,1,1,1,‘是否学生2’,,‘shil’,GETDATE(),,‘shil’,GETDATE(),0)
fetch next from WS_Student_cursor into @id ,@Name
END
close WS_Student_cursor
deallocate WS_Student_cursor

sqlserver 循环语句（sqlserverfor循环）

相关推荐