declare @EipSubMumber varchar(10)
set @EipSubMumber =
case
when @@identity> 0 and @@identity<10 then '000' + convert(varchar,@@identity)
when @@identity>= 10 and @@identity<100 then '00' + convert(varchar,@@identity)
when @@identity>= 100 and @@identity<1000 then '0' + convert(varchar,@@identity)
else convert(varchar,@@identity)
end
set @EipSubMumber =
case
when @@identity> 0 and @@identity<10 then '000' + convert(varchar,@@identity)
when @@identity>= 10 and @@identity<100 then '00' + convert(varchar,@@identity)
when @@identity>= 100 and @@identity<1000 then '0' + convert(varchar,@@identity)
else convert(varchar,@@identity)
end