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)

How to fetch the next row from a cursor with a "fetch" statement?

600

---

How to create an inline table-valued function?

542

---

What types of Joins are possible with Sql Server?

560

---

Explain the different index configurations a table can have?

514

---

What is user defined stored procedures?

574

---

---

Where are stored procedures in sql server?

574

---

What is ms sql server service broker?

530

---

What are xml indexes?

536

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

586

---

Do you know the capabilities of cursors?

543

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

513

---

How to create user defined functions with parameters?

650

---

Is truncate a dml command?

510

---

Explain what is sql server english query?

537

---

what is difference between NULL and ISNULL in SQL Server 2008?

586

---