Use Atlantic;
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.usp_Insert_Into_Atlantic_Employees') AND type = 'P')
DROP PROCEDURE dbo.usp_Insert_Into_Atlantic_Employees;
GO
CREATE PROCEDURE dbo.usp_Insert_Into_Atlantic_Employees
AS
INSERT INTO AtlanticEmployees VALUES ('Carmen',1000);
INSERT INTO AtlanticEmployees VALUES ('Rick',1200);
INSERT INTO AtlanticEmployees VALUES ('John',1100);
INSERT INTO AtlanticEmployees VALUES ('Stephen',1300);
INSERT INTO AtlanticEmployees VALUES ('Maria',1400);
INSERT INTO AtlanticEmployees VALUES ('Susan',1450);
INSERT INTO AtlanticEmployees VALUES ('Carl',1850);