34,587
社区成员
发帖
与我相关
我的任务
分享
UPDATE JiHuaShengYu SET
huKouDiZhi=NULL
,huJiXinqZhi=NULL
,xianZhuDiZhi=NULL
WHERE xxxx=?
;with cte as
(
select
HangBiaoShi,
UserCode,
shiFouDuShe,
hunYinZhuan
from TB
)
select
HangBiaoShi,
UserCode,
shiFouDuShe,
hunYinZhuan
into #T
from cte
go
truncate table TB
go
insert into TB(
HangBiaoShi,
UserCode,
shiFouDuShe,
hunYinZhuan
)select
HangBiaoShi,
UserCode,
shiFouDuShe,
hunYinZhuan
from #tb
go
drop table #T
go
select * from TB