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)

Write a query for primary key constraint with identity key word?

1029

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

974

---

Why we need sql server?

960

---

What are null values in ms sql server?

1082

---

How to install sql server 2005 express edition?

1120

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1007

---

How many levels of sp nesting is possible?

1051

---

Explain stored procedure?

1050

---

Does hive support indexing?

959

---

What happens when the SQL Azure database reaches Max Size?

111

---

What is meant by indexing files?

1039

---

What are three major types of constraints?

1115

---

How to loop through result set objects using odbc_fetch_row()?

976

---

How is SQL Azure different than SQL server?

225

---

what is the system function to get current user's user id? : Sql server database administration

1000

---