用存储过程写的产生的编号 begin set @s = '0000' +cast( @newno as varchar(30)) set @s = @up_LoginCode + Right(@s,4) select @hasRecord =count(*) from departinfo where Depart_LoginCode=@s and Depart_TopDepart_ID= @UpDepartID if(@hasRecord=0) break else set @newno=@newno+1 end update d