Hi,
Please refer below SQL Script
SQL
CREATE TABLE Region(region_id VARCHAR(2),region_name VARCHAR(30))
CREATE PROCEDURE InsertRegion
@region_id VARCHAR(2),
@region_name VARCHAR(30)
AS
BEGIN
IF NOT EXISTS (SELECT COUNT(region_id) FROM Region WHERE region_id = @region_id)
BEGIN
INSERT INTO @region VALUES(@region_id,@region_name)
END
ELSE
BEGIN
RAISEERROR('Region Already Exists',16,1)
END
END
I hope this will help you out.