ALTER TABLE tablename
ADD num int,
c nvarchar(254)
;WITH CTE AS (
SELECT *,
ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS rownum
FROM test
)
UPDATE CTE
SET num = rownum
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交