Loading

find the primary and foreign key existence

faiz khan

i have two table employee table and department table.

in employee table primary key table and foreign key in department table.

i am inserting data using primary key and foreign key.once i inserting duplicate data in department table so i am getting error.

i want to check if the value is already exsist in department table.please give me some links where i can check some examples

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Barik9y ago
Before inserting the records in to Department table, check whether the data exist in the department table for that employee, if not then insert.
Ex:

IF not Exists (SELECT
1
FROM dbo.Department
WHERE EmployeeID = @YourParamEmployeeID) BEGIN
-- Write your insert statement..
end
0
Rajkiran Swain9y ago
http://www.w3resource.com/sql/joins/using-a-where-cluase-to-join-two-tables-related-by-a-single-column-primary-key-or-foriegn-key-pair.php
0