34,593
社区成员
发帖
与我相关
我的任务
分享
DECLARE CURSOR1 CURSOR FOR SELECT * FROM TABLE1
OPEN CURSOR1
FETCH NEXT FROM CURSOR1 INTO 这里声明变量接收你所要的值
WHILE @@FETCH_STATUS=0
BEGIN
UPDATE TABLE1 SET PRTQ=@PRTQ WHERE ID = (SELECT ID FROM TABLE2 WHERE 条件 )
END
update tb set ptrq=cast(ptrq*rand() as int)
update 表 set ptrq=cast(ptrq*rand() as int)
update 表 set ptrq=cast(2134243*rand() as int)