--1、声明游标 指定有表指定的是数据库的哪一个字段.(在这里只能选择作为主键的id)
DECLARE @user_id varchar(36) --可写多个
DECLARE user_extension_cursor CURSOR
FOR
SELECT id --可写多个
FROM dbo.TableFP where TRZJ is null --可写条件
--2、需要用FETCH来获取游标
OPEN user_extension_cursor;
FETCH NEXT FROM user_extension_cursor
INTO @user_id --可写多个
--3、循环更新字段的值
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE dbo.TableFP
SET TRZJ = cast(ceiling(rand() * 500) as int)
WHERE ID = @user_id --可写多个
FETCH NEXT FROM user_extension_cursor
INTO @user_id --可写多个
END
CLOSE user_extension_cursor;
DEALLOCATE user_extension_cursor;
DECLARE @user_id varchar(36) --可写多个
DECLARE user_extension_cursor CURSOR
FOR
SELECT id --可写多个
FROM dbo.TableFP where TRZJ is null --可写条件
--2、需要用FETCH来获取游标
OPEN user_extension_cursor;
FETCH NEXT FROM user_extension_cursor
INTO @user_id --可写多个
--3、循环更新字段的值
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE dbo.TableFP
SET TRZJ = cast(ceiling(rand() * 500) as int)
WHERE ID = @user_id --可写多个
FETCH NEXT FROM user_extension_cursor
INTO @user_id --可写多个
END
CLOSE user_extension_cursor;
DEALLOCATE user_extension_cursor;