Hi,
In my Insert SP, I have 5 local variables:
@MemberID int,
@VideoID int,
@Total money,
@DateRented datetime,
@DateDue datetime
In my Insert SP, I have 5 local variables:
@MemberID int,
@VideoID int,
@Total money,
@DateRented datetime,
@DateDue datetime
insert into RentalRecord
values (@MemberID,@VideoID,@Total,GETDATE(), DATEADD(dd,5,GETDATE()))
When I try to execute the SP, I get this error:
Procedure or function ’sp_AddRentalRecord’ expects parameter ‘@DateRented’, which was not supplied.
Please advise.
Thanks
Loading ...