Answer Posted / pravati

foreign key of one table points to a primary key of another table.

How to bind a view to the schema of the underlying tables?

1007

---

What encryption security is available in sql azure?

101

---

What are the types of stored procedures in an sql server?

1000

---

What are the advantages of user-defined functions over stored procedures in sql server?

1055

---

Differentiate between delete and truncate.

1071

---

Explain syntax for viewing, dropping and disabling triggers?

968

---

Does partitioning improve performance?

987

---

How to create new tables with "select ... Into" statements in ms sql server?

1003

---

What is row_number function?

1018

---

How to delete a database in ms sql server?

1246

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

1102

---

What is the difference between row_number and dense_rank?

893

---

What are different types of views?

954

---

What is the command to change the recovery model?

1057

---

What is a cube? : sql server analysis services, ssas

1011

---