What is difference between stored procedure and user defined function?

1097

---

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

953

---

What’s the use of custom fields in report?

937

---

What is the function of sql server agent windows service?

1089

---

What are different types of replication in sql server?

1082

---

Explain partitioned view?

1068

---

Describe in brief databases and sql server databases architecture.

1008

---

What are commit and rollback in sql?

1122

---

How many levels of sp nesting are possible?

1018

---

Explain database partitioning. What is its importance?

1192

---

Explain phantom deadlock?

1230

---

What is the importance of database partitioning?

1058

---

Explain the table term used in database.

1035

---

What do you mean by database?

1074

---

Explain artificial key?

1168

---