SqlServer 2008：写一个插入时生成流水号的存储过程，错误提示有参数没有提供，求助！

Question

create procedure insert_booking_procedure 
@bno varchar(15),
@pno int,
@dno int,
@condition varchar(10),
@number varchar(2),
@date varchar(10),
@period varchar(2),
@bookableno varchar(15),
@createtime smalldatetime
as
begin
declare @id varchar(15),@id1 int,@head varchar(8)

set @head=convert(varchar,getdate(),112)
select @id=max(bookableno) from booking where bookableno like @head+'%'
if @id is null
begin
    set @id1=0
end

else
begin
	set @id1=cast(substring(@id,9,5) as int)
end

set @bno=@head+right('00000'+cast(@id1 as varchar),5)
set @createtime=GETDATE()

insert 
into booking 
(bno,pno,dno,condition,number,date,period,bookableno,createtime) 
values(@bno ,@pno, @dno, @condition, @number, @date, @period, @bookableno, @createtime)
end

 

Answer 1

你在execute执行存储过程时少传了个参数@bno