34,588
社区成员
发帖
与我相关
我的任务
分享
create table #p
(
id int,
Money int
)
insert into #p select 1,50
select * from #p
id Money
----------- -----------
1 50
(1 row(s) affected)
UPDATE #p SET Money=Money+10
Where ID in (1)
select * from #p
id Money
----------- -----------
1 60
(1 row(s) affected)