Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT EmployeeID, ProjectID
- INTO #EmployeesProjects
- FROM EmployeesProjects
- DROP TABLE EmployeesProjects
- CREATE TABLE EmployeesProjects
- (
- EmployeeID INT FOREIGN KEY REFERENCES Employees(EmployeeID) NOT NULL,
- ProjectID INT FOREIGN KEY REFERENCES Projects(ProjectID) NOT NULL
- )
- SELECT * FROM EmployeesProjects
- INSERT INTO EmployeesProjects
- SELECT EmployeeID, ProjectID
- FROM #EmployeesProjects
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement