Server: Msg 201, Level 16, State 4, Procedure SP_New_OrderNo, Line 0 Procedure 'SP_New_OrderNo' expects parameter '@ERROR', which was not supplied.
CREATE PROCEDURE SP_New_OrderNo @CustomerNo NVARCHAR(10), @ModelNo NVARCHAR(10), @ERROR VARCHAR(100)OUTPUT AS BEGIN SET NOCOUNT ON; DECLARE @CusNo NVARCHAR(50) DECLARE @MdlNo NVARCHAR(50) SELECT @CusNo=CustomerNo, @MdlNo=ModelNo FROM TblSerialNo WHERE CustomerNo=@CustomerNo IF @CusNo=@CustomerNo BEGIN IF @MdlNo=@ModelNo BEGIN SET @ERROR = 'THIS CUSTOMER NO. AND MODEL NO. IS IN DATABASE PLEASE ENTER SERIAL NUMBER' END ELSE BEGIN SET @ERROR = 'THIS CUSTOMER NO. IS IN DATABASE PLEASE ENTER MODELNO AND SERIAL NUMBER' END END ELSE BEGIN SET @ERROR = 'PLEASE ENTER CUSTOMER NO.' INSERT INTO TblSerialNo (CustomerNo, ModelNo) VALUES (@CustomerNo, @ModelNo) END END GO EXEC SP_New_OrderNo '111','123'
EXEC SP_New_OrderNo '111','123'
declare @error varchar(100) exec yourStoredProcedureName '111','123', @error output print @error
@ERROR VARCHAR(100) OUTPUT
EXEC SP_New_OrderNo '111','123', @ERROR OUTPUT SELECT @ERROR
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)