Stored Procedure Add record (INSERT)

GO
IF OBJECT_ID(‘AddProgram’,’P’)IS NOT NULL
DROP PROCEDURE AddProgram

GO
CREATE PROCEDURE AddProgram
@ProgramCode VARCHAR(10) = NULL,
@Description VARCHAR(60) = NULL

AS
DECLARE @Success INT
SET @Success = 1

IF @ProgramCode IS NULL
RAISERROR(‘AddProgram Required parameter:@ProgramCode’,16,1)
ELSE
BEGIN
INSERT INTO
Program
VALUES(@ProgramCode,@Description)

IF @@ERROR = 0
SET @Success = 0
ELSE
RAISERROR(‘AddProgram SELECT Error FROM Program table.’,16,1)
END
RETURN @Success

GO
/*EXECUTE AddProgram ‘1234’,’test data’*/