If you are working with the temporary tables than keep in mind you cannot make foreign key relationships to other tables. Check out the T-SQL code below.

CREATE TABLE #Person 
(
PersonID int identity(1,1) PRIMARY KEY,
FirstName nvarchar(20), 
LastName nvarchar(20) 
)

CREATE TABLE #Phone
(
PhoneID int identity(1,1) PRIMARY KEY, 
PhoneNumber nvarchar(20), 
PersonID int FOREIGN KEY REFERENCES Person(PersonID) -- Naa cannot do this Dude!!
ON DELETE NO ACTION  
)

 

 


powered by IMHO