create proc sp_kk
as
select * into #temp1 from bonstableupdate from bonstable set csacstype='首期' where csacstype='ic'
drop table #temp1
然后在
exec sp_kk
as
select * into #temp1 from bonstableupdate from bonstable set csacstype='首期' where csacstype='ic'
drop table #temp1
然后在
exec sp_kk
update from bonstable set csacstype='首期' where csacstype='ic'
select * into #temp1 from bonstableupdate from #temp1 set csacstype='首期' where csacstype='ic'
drop table #temp1
case csacstype when 'ic' then '首期' else csacstype end as csacstype
from bonstable