find the primary and foreign key existence

Question

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

Ramesh Barik · Answer

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

Rajkiran Swain · Answer

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