Answer Posted / tanaji

A candidate key is a combination of attributes that can be uniquely used to identify a database record without any extraneous data. Each table may have one or more candidate keys. One of these candidate keys is selected as the table primary key.

When to use null data driven subscription?

207

---

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

1020

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2073

---

What is the security model used in sql server 2005?

1010

---

What is the difference between ddl and dml?

1048

---

How to perform key word search in tables?

961

---

What is sub-query in sql server?

1205

---

Define indexes?

1045

---

What is normalization and denormalization in sql server?

1017

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1013

---

What is filestream?

1001

---

how you can deploy an ssrs report?

178

---

What are subqueries in sql server? Explain its properties.

1019

---

Is null in sql server?

994

---

What is the difference between lock, block and deadlock? : sql server database administration

1047

---