Listing 3: Insert New Employees and Order

SET IDENTITY_INSERT dbo.Employees ON;
INSERT INTO dbo.Employees(EmployeeID, FirstName, LastName, Country, City)
  VALUES(10, 'Itzik', 'Ben-Gan', 'Middle Earth', 'Hobitton');
INSERT INTO dbo.Employees(EmployeeID, FirstName, LastName, Country, City)
  VALUES(11, 'Lilach', 'Ben-Gan', 'Middle Earth', 'Hobitton');
SET IDENTITY_INSERT dbo.Employees OFF;
SET IDENTITY_INSERT dbo.Orders ON;
INSERT INTO dbo.Orders(OrderID, EmployeeID)
  VALUES(12345, 11);
SET IDENTITY_INSERT dbo.Orders OFF;