Question

sqlserver如何同时更新多条数据？

比如有个表是按照主键id排序的
我希望前10行的tdate字段update
应该如何做？

Answer 1

如果你要跟新多条数据的话
update 表 set 字段=你修改的内容 where id in (select top 10 Id from 表)

Answer 2

update set xxx=xxx+5 from tb where id<=10

Answer 3

update tdate..... where id in (select top 10 id)

Answer 4

update 表 set tdate = '' where id in (select top 10 id from 表 order by id)

Answer 5

UPDATE TOP 10 <table_name>
SET tdate=******