create PROCEDURE [dbo].[INSERT_DSE]
@DSE_FirstName varchar(50),
@DSE_LastName varchar(50),
@DSE_MiddleName varchar(50),
@DSE_EmployeeID varchar(20),
@Address varchar(MAX),
@MobileNo int,
@Photo binary(50),
@PhotoID_Type varchar(50),
@PhotoID_No varchar(50),
@JoiningDate datetime,
@LeavingDate datetime,
@CreatedBy varchar(50),
@UpdatedBy varchar(50),
@AreaID int,
@RouteID int,
@ProductID int,
@StockID int,
@UserID int,
@MSG VARCHAR(10) OUT
-- )
AS
BEGIN
BEGIN TRY
INSERT INTO DSE_Info
VALUES (
@DSE_FirstName,
@DSE_LastName,
@DSE_MiddleName,
@DSE_EmployeeID,
@Address,
@MobileNo,
@Photo,
@PhotoID_Type,
@PhotoID_No,
@JoiningDate,
@LeavingDate,
1,
@CreatedBy,
GETDATE(),
@UpdatedBy,
GETDATE(),
@AreaID,
@RouteID,
@ProductID,
@StockID,
@UserID
)
SET @MSG='SUCCESS'
END TRY
BEGIN CATCH
SET @MSG = 'FAILED'
END CATCH
END
try this