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

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

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;