34,838
社区成员




--> --> 听雨停了-->测试数据
if not object_id(N'Tempdb..#tab') is null
drop table #tab
Go
Create table #tab(id int,name nvarchar(21))
Insert #tab
select 1,N'x' union all
select 2,N'y'
--测试数据结束
;with cte as (
SELECT a.*,b.id AS update_ID from #tab a
INNER JOIN #tab b ON a.id<>b.id
WHERE a.id IN (1,2) AND b.id IN (1,2)
)
UPDATE a SET id=b.update_ID
FROM #tab a
INNER JOIN cte b ON a.id=b.id
SELECT * FROM #tab
id name
----------- ---------------------
2 x
1 y
update t
set A = case when A = 3 then 4 else 3 end
where a in (3,4)
[/quote]
楼主的意思写一个存储过程,可以动态传参,交换任意两条记录的结果,你这么搞不是把楼主往坑里带吗
update t
set A = case when A = 3 then 4 else 3 end
where a in (3,4)
[/quote]
楼主的意思写一个存储过程,可以动态传参,交换任意两条记录的结果,你这么搞不是把楼主往坑里带吗
update t
set A = case when A = 3 then 4 else 3 end
where a in (3,4)
[/quote]
楼主的意思写一个存储过程,可以动态传参,交换任意两条记录的结果,你这么搞不是把楼主往坑里带吗
update t
set A = case when A = 3 then 4 else 3 end
where a in (3,4)
[/quote]
楼主的意思写一个存储过程,可以动态传参,交换任意两条记录的结果,你这么搞不是把楼主往坑里带吗
update t
set A = case when A = 3 then 4 else 3 end
where a in (3,4)