Advertisement
Aliendreamer

2problem fom octomber 2017 exam

Jun 18th, 2018
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.62 KB | None | 0 0
  1. INSERT INTO [Employees] (FirstName,LastName,Gender,Birthdate,DepartmentId)VALUES
  2. ('Marlo','O’Malley','M','9/21/1958',1),
  3. ('Niki','Stanaghan','F','11/26/1969',4),
  4. ('Ayrton','Senna','M','03/21/1960',9),
  5. ('Ronnie','Peterson','M','02/14/1944',9),
  6. ('Giovanna','Amati','F','07/20/1959',5)
  7.  
  8. INSERT INTO [Reports] (CategoryId,StatusId,OpenDate,CloseDate,Description,UserId,EmployeeId) VALUES
  9. (1,1,'04/13/2017',NULL,'Stuck Road on Str.133',6,2),
  10. (6,3,'09/05/2015','12/06/2015','Charity trail running',3,5),
  11. (14,2,'09/07/2015',NULL,'Falling bricks on Str.58',5,2),
  12. (4,3,'07/03/2017','07/06/2017','Cut off streetlight on Str.11',1,1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement