sql proc 创建报卡的存储过程......

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 outputasbegin 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 @outstrend