Advertisement
Guest User

Untitled

a guest
Jul 5th, 2015
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.40 KB | None | 0 0
  1. SELECT EmployeeID, ProjectID
  2. INTO #EmployeesProjects
  3. FROM EmployeesProjects
  4.  
  5. DROP TABLE EmployeesProjects
  6.  
  7. CREATE TABLE EmployeesProjects
  8. (
  9.     EmployeeID INT FOREIGN KEY REFERENCES Employees(EmployeeID) NOT NULL,
  10.     ProjectID INT FOREIGN KEY REFERENCES Projects(ProjectID) NOT NULL
  11. )
  12.  
  13. SELECT * FROM EmployeesProjects
  14.  
  15. INSERT INTO EmployeesProjects
  16. SELECT EmployeeID, ProjectID
  17. FROM #EmployeesProjects
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement