SQL-Script.sql

CREATE TABLE Employee (
  id INT IDENTITY (1,1) PRIMARY KEY NOT NULL ,
  name NVARCHAR(50) NOT NULL ,
  address NVARCHAR(50) NOT NULL ,
  phone VARCHAR(11) NOT NULL ,
  salary INT NOT NULL
);

INSERT INTO Employee(name, address, phone, salary)
    VALUES
      (N'Phan Bá Hải', N'Long An', '0974839283', 7000000),
      (N'Phan Phú Kiệt', N'Bình Dương', '0938493849', 6500000),
      (N'Trần Thanh Khang', N'Bến Tre', '0938293829', 6000000),
      (N'Trần Hữu Sỹ', N'TP.HCM', '0945849586', 6500000),
      (N'Nguyễn Thị Huỳnh Như', N'Quảng Bình', '0918928392', 5000000)