temp table
create table #temp1(fmname nvarchar(255), emigra nvarchar(255))
insert into FMToEmigraMapping select fmname,emigra from #temp
insert into #temp1(fmname) select emigrafieldname from FMToEmigraMapping
update FMToEmigraMapping set FMFieldname=emigra from #temp where FMToEmigraMapping.EmigraFieldName=#temp.fmname
row top
select * into aa from fmtoemigramapping
select * from (select *,case CurrencyID when 1 then 1
when 5 then 1
when 9 then 1
else 0
end as new from currency) currency
order by new desc
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。