create proc [dbo].[addCards] @startNo int, @endNo int, @newspaper varchar(5), @payment varchar(5), @cardType varchar(5), @years varchar(5), @unitprice money, @startDate smalldatetime, @endDate smalldatetime, @outstr tinyint output as begin declare @cardIndex varchar(10) declare @cardpsw varchar(10) set @cardIndex=@newspaper+@payment+@cardType+@years while @startNo<= @endNo begin set @cardpsw=LEFT(LOWER(NEWID()),8) insert into cards(cardID,cardpsw,sn,cardIndex,newspaper,payment,cardType,years,unitprice,startDate,endDate) values(@cardIndex+convert(varchar(20),right('0000000'+ltrim(@startNo),7)),@cardpsw,@startNo,@cardIndex,@newspaper,@payment,@cardType,@years,@unitprice,@startDate,@endDate) set @startNo=@startNo+1 end if @@error=0 set @outstr=0 else set @outstr=1 return @outstr end
