Use Atlantic;
GO
IF EXISTS (SELECT * FROM sys.tables WHERE OBJECT_ID = OBJECT_ID(N'AtlanticEmployees') AND TYPE IN (N'U'))
DROP TABLE AtlanticEmployees;
GO
CREATE TABLE AtlanticEmployees
(
emp_id INT IDENTITY
, emp_Name NVARCHAR(100)
, emp_Sal DECIMAL (10,2) CHECK (emp_Sal > 0)
, CONSTRAINT PK_AtlanticEmployees PRIMARY KEY (emp_id)
);
GO
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);
GO
SELECT *
FROM AtlanticEmployees