sql server导入表的一些函数使用

truncate table JC_BMDA;
insert into JC_BMDA(bh,mc,qdmc,pym,ty)
select right('0'+rtrim(convert(varchar(5),id)),2) bh,bz,
'jnx',upper(dbo.fGG_GetPY(bz)),0
from (
select ROW_NUMBER() over(order by xh) as id,* 
from (
  select convert(int,max(xh)) as xh ,bz from aaa group by bz 
) aa) bb;
select * from jc_bmda;

truncate table JC_YGDA;
insert into JC_YGDA(bh,xm,xb,pym,idbm,ty,jdr)
select a.gh,a.xm,'男',upper(dbo.fGG_GetPY(a.xm)),b.id,0,'管理员'  
from aaa a inner join JC_BMDA b on a.bz=b.mc;
select * from JC_YGDA;