Please help me to create a insert query (error of foreign key constrant)
- by Rajesh Rolen- DotNet Developer
I want to move data from one database's table to another database's table its giving me foreign key error. please tell me how can i insert all those data which is valid except those rows who have error of foreign key. i am using sql server 2005
My query is :
SET IDENTITY_INSERT City ON
INSERT INTO City…