SQLServer更新数据库每行一个随机数

最新推荐文章于 2022-11-02 10:54:21 发布

weixin_30575309

最新推荐文章于 2022-11-02 10:54:21 发布

阅读量639

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/weiweithe/p/4390287.html

版权

代码：

DECLARE @user_id varchar(36)
DECLARE user_extension_cursor CURSOR
FOR
SELECT UserCode
FROM Users
OPEN user_extension_cursor;
FETCH NEXT FROM user_extension_cursor
INTO @user_id

WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE Users
set UserLevel=cast(ceiling(rand() * 5) as int)
WHERE UserCode = @user_id
FETCH NEXT FROM user_extension_cursor INTO @user_id
END
CLOSE user_extension_cursor;
DEALLOCATE user_extension_cursor;