--数据测试 declare @table1 table(id int,beizhu text) insert into @table1 select 1,'asd...' union all select 2,'fdsa...'update @table1 set beizhu=b.beizhu from @table1 a,(select beizhu from @table1 where id=2) b where a.id=1select * from @table1
--这样写: update table1 set beizhu=b.beizhu from table1 a,(select beizhu from table1 where id=2) b where a.id=1
declare @table1 table(id int,beizhu text)
insert into @table1
select 1,'asd...'
union all select 2,'fdsa...'update @table1 set beizhu=b.beizhu
from @table1 a,(select beizhu from @table1 where id=2) b
where a.id=1select * from @table1
update table1 set beizhu=b.beizhu
from table1 a,(select beizhu from table1 where id=2) b
where a.id=1