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)

Explain filestream storage of sql server 2008?

1024

---

What is sql server management studio? : sql server management studio

1084

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1938

---

What is failover clustering overview?

1095

---

Explain the benefits of user-defined functions?

1067

---

what is the sql equivaent of the dataset relation object ?

2030

---

How can sql server instances be hidden? : sql server security

1154

---

What do you understand by integration services in sql server?

968

---

What do you mean by 'normalization'?

1069

---

Can a table have 2 foreign keys?

910

---

Why I can not enter 0.001 second in date and time literals in ms sql server?

1068

---

How self join is different from outer join?

1124

---

What do you mean by an execution plan?

1120

---

What is optimization and its types?

988

---

How many types of built in functions are there in sql server 2012?

926

---