34,576
社区成员
发帖
与我相关
我的任务
分享
declare @str varchar(10)
set @str='Test'
update #t set Field1=@str,Field2=Field1
create table #t (field1 varchar(10),field2 varchar(10))
insert #t select 'a','b'
declare @str varchar(10)
set @str='Test'
update #t set Field1=@str,@str=Field2,Field2=Field1
select * from #t
drop table #t
/*field1 field2
---------- ----------
b a
(1 行受影响)*/
create table #t (field1 varchar(10),field2 varchar(10))
insert #t select 'a','b'
declare @str varchar(10)
update #t set Field1=Field2,Field2=Field1
select * from #t
/*
field1 field2
---------- ----------
b a
*/
字段之间同时更新
declare @str varchar(10)
set @str='Test'
update #t set Field1=Field2,Field2=Field1
create table #t (field1 varchar(10),field2 varchar(10))
insert #t select 'a','b'
declare @str varchar(10)
set @str='Test'
update #t set Field1=@str,Field2=@str
select * from #t
--drop table #t
/*
field1 field2
---------- ----------
Test Test
*/
declare @str varchar(10)
set @str='Test'
update #t set Field1=@str,Field2=Field1
--你这样试下
declare @str varchar(10)
set @str='Test'
update #t set Field1=@str,@str=Field2,Field2=Field1