34,587
社区成员
发帖
与我相关
我的任务
分享
-- 先把原先的cusNo,cusName备份到cusInfo_temp中
select cusNo,cusName
into cusInfo_temp
from cusIfo
-- 然后在在cusInfo_temp表中更改cusNo的值
update a
set a.cusNo=left(a.cusNo,2)+cast(cusCredit as varchar(2))+substring(a.cusNo,3,100)
from cusInfo_temp a
inner join cusIfo b
on a.cusNo=b.cusNo
select cusNo=stuff(cusNO,3,0,rtrim(cusCredit)),cusName into cusInfo_temp from cusInfo
update cusInfo
set cusNO=stuff(cusNO,3,0,rtrim(cusCredit))
select cusNo=stuff(cusNO,3,0,rtrim(cusCredit)),cusName into cusInfo_temp from cusInfo
Create table cusInfo_temp(cusNo varchar(50),cusName varchar(50))
insert into cusInfo_temp
select cusNo,cusName from cusInfo
select cusNo,cusName into cusInfo_temp from cusInfo