34,587
社区成员
发帖
与我相关
我的任务
分享
declare @id int ;
select @id=max(id) from tb;
update tb set 科室='xxx' where id=@id;
-- 凑个人数
create table test(id int , name varchar(10))
go
insert into test values(1,'XXX'),(3,'YYY'),(2,'ggg')
go
print '--前'
select * from test
go
with m as (select top 1 * from test order by id desc)
update m set name = '科室'
go
print '--后'
select * from test
go
drop table test
go
--前
id name
----------- ----------
1 XXX
3 YYY
2 ggg
(3 行受影响)
(1 行受影响)
--后
id name
----------- ----------
1 XXX
3 科室
2 ggg
(3 行受影响)
UPDATE [dbo].[test]
SET [科室] = '科室'
where id = (select max(id) from [test])