What is difference between stored procedure and user defined function?

1029

---

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

911

---

What’s the use of custom fields in report?

889

---

What is the function of sql server agent windows service?

1029

---

What are different types of replication in sql server?

1030

---

Explain partitioned view?

1021

---

Describe in brief databases and sql server databases architecture.

942

---

What are commit and rollback in sql?

1052

---

How many levels of sp nesting are possible?

958

---

Explain database partitioning. What is its importance?

1134

---

Explain phantom deadlock?

1179

---

What is the importance of database partitioning?

1008

---

Explain the table term used in database.

983

---

What do you mean by database?

1024

---

Explain artificial key?

1111

---