What is difference between stored procedure and user defined function?

1106

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

960

---

What’s the use of custom fields in report?

944

---

What is the function of sql server agent windows service?

1097

---

What are different types of replication in sql server?

1085

---

Explain partitioned view?

1077

---

Describe in brief databases and sql server databases architecture.

1009

---

What are commit and rollback in sql?

1126

---

How many levels of sp nesting are possible?

1026

---

Explain database partitioning. What is its importance?

1198

---

Explain phantom deadlock?

1235

---

What is the importance of database partitioning?

1061

---

Explain the table term used in database.

1037

---

What do you mean by database?

1081

---

Explain artificial key?

1173

---