Answer Posted / manoj pandey

Foreign Key is used to establish Referential Integrity/Constraint between 2 tables. Mainly it is a column in a table that uniquely identifies every record in another table. A table can have 1 or more than 1 FKs.

~Manoj (sqlwithmanoj.wordpress.com)

Is candidate a key?

947

---

Differentiate between mongodb vs. Sql server?

1095

---

What is a select query statement in ms sql server?

1075

---

What are transactions in sql?

1060

---

If the job running very slow what is the action you do

1892

---

What do you mean by 'normalization'?

1060

---

What are logical database components? : SQL Server Architecture

1035

---

What does it mean to invest in the index?

973

---

What is resultset concur_updatable?

1019

---

What is primary key and example?

954

---

What is the difference between a function and a stored procedure?

1070

---

What is the maximum size of sql server database?

1009

---

How to find which stored procedure is currently running in sql server?

995

---

How many null values we can have in a unique key field in sql server?

958

---

How to create a simple user defined function in ms sql server?

1021

---