SQl分支语句

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