DECLARE cursor_Ant CURSOR FOR --cursor_Ant为游标名
(
select [User_Name],[Password] from [Sys_User] --定义游标将指向的行
)
declare @User_Name nvarchar(1000)
declare @Password nvarchar(1000)
OPEN cursor_Ant --打开游标
FETCH NEXT FROM cursor_Ant into @User_Name,@Password --游标指向一行
while @@fetch_status=0 -- 0 :FETCH 语句成功。 -1FETCH 语句失败或此行不在结果集中。-2:被提取的行不存在。
BEGIN
IF (@Password='888888')begin
print @User_Name
UPDATE Sys_User SET Remarks =@User_Name WHERE [User_Name]=@User_Name
end
FETCH NEXT FROM cursor_Ant into @User_Name,@Password --游标指向下一行
end
close cursor_Ant --关闭游标
DEALLOCATE cursor_Ant --删除游标