34,589
社区成员
发帖
与我相关
我的任务
分享
create database test
go
use test
go
create table test(id int primary key, name varchar(10), flag int default 0)
go
insert into test(id, name)
values(1, 'xxx'),(2, 'yyy'),(3, 'zzz'),(4, 'ppp')
go
-- 这段可以执行多次,看一下效果。
declare @id int
update test set @id = id, name = 'xxxA', flag =1
where id = (select top 1 id from test where flag = 0 order by id)
print @id
go
select * from test
go
use master
go
drop database test
go