What is difference between stored procedure and user defined function?

1172

---

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

997

---

What’s the use of custom fields in report?

989

---

What is the function of sql server agent windows service?

1150

---

What are different types of replication in sql server?

1147

---

Explain partitioned view?

1133

---

Describe in brief databases and sql server databases architecture.

1069

---

What are commit and rollback in sql?

1170

---

How many levels of sp nesting are possible?

1070

---

Explain database partitioning. What is its importance?

1255

---

Explain phantom deadlock?

1271

---

What is the importance of database partitioning?

1101

---

Explain the table term used in database.

1082

---

What do you mean by database?

1149

---

Explain artificial key?

1215

---