What is difference between stored procedure and user defined function?

1170

---

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

996

---

What’s the use of custom fields in report?

986

---

What is the function of sql server agent windows service?

1148

---

What are different types of replication in sql server?

1144

---

Explain partitioned view?

1131

---

Describe in brief databases and sql server databases architecture.

1065

---

What are commit and rollback in sql?

1170

---

How many levels of sp nesting are possible?

1068

---

Explain database partitioning. What is its importance?

1253

---

Explain phantom deadlock?

1269

---

What is the importance of database partitioning?

1100

---

Explain the table term used in database.

1080

---

What do you mean by database?

1148

---

Explain artificial key?

1215

---