| As name suggest Output means something to get return from procedure by declareing Output type in procedure below code will help us.
CREATE PROCEDURE ProceduerName
@Column1 varchar(50),
@Column2 varchar(50),
@Column3 varchar(50),
@OutputVal VARCHAR(100) OUT
AS
BEGIN
SET NOCOUNT ON;
---Checking Condition if for exists or not
IF NOT EXISTS(SELECT * FROM tablename WHERE columnname=@value)
BEGIN
INSERT INTO tablename
(
Column1,
Column2,
Column3
)
VALUES
(
@Column1,
@Column2,
@Column3
)
--If query Successfully execute I am returing the below Message as Output Parameter
SET @OutputVal=@Column1+' Created Successfully'
END
ELSE
BEGIN
--If record already Exists i am returning this Message as Output Parameter
SET @OutputVal=@Column1 + ' Already Exists'
END
END
| | |