摘要: 1.更新表中某个字段为随机值 update [Courses] set LearnsNum = cast(rand(checksum(newid()))*(999-100)+100 as int) 以下可参考,非原创 update [test].[dbo].[table] set [table.ra 阅读全文