sql两张表多字段更新语句、字符串型转变为int型排序

update gsglsjdb.gs_jl_rgrd a
set (a.swdjzh,a.nsrmc)=(select b.swdjzh,b.nsrmc from djdb.dj_jl_jbsj b where a.jsjdm=b.jsjdm) 
where exists (select * from djdb.dj_jl_jbsj where jsjdm=a.jsjdm); 

此sql语句为：拿到jbsj表中的swdjzh和nsrmc，更新rgrd表中的swdjzh和nsrmc字段

select id,jsjdm,nsrmc,pcyy from gsglsjdb.pcmd2_bak order by jsjdm,cast(id AS int) desc;

此sql语句为：把字符型的id字段当成int型字段排序