用0补齐11位的‘校内编号’与表合并

UPDATE [ECard-Test].[dbo].[class]
   SET [xnbh] = RIGHT('00000000000' + CAST(dbo.Class.xnbh AS nvarchar(11)), 11)

 

insert into BZRYXXB
select *
from Staff
union
select * from StudentFromJWC


insert into student (studentname,studentinstitute,StudentClass) select xm,lsdwm,lsdwm1 from [BZRYXXB-jwc]