Answer / Hari Shankar

To implement SQL Server Service Broker, follow these steps:
n
1. Create a queue and service for each dialog.
2. Define the conversation group that will be used by the dialogs.
3. Establish a dialog between two services using the OPEN DIALOG statement.
4. Send messages between the dialogs using the SEND statement.
5. Close the dialog when no more messages need to be sent or received.

What is the benefit of normalization?

1 Answers  

---

What is a database in ms sql server?

1 Answers  

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---

What is table-valued sub query?

1 Answers  

---

What is co-related sub query?

1 Answers  

---

What is stored procedures?

1 Answers  

---

How do you manipulate data?

1 Answers  

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1 Answers  

---

What is Lock table in SQL?

1 Answers   Wipro,

---

What is the difference between functions and scalar functions?

1 Answers   EXL,

---

When do you think a developer should use sql server-based cursors?

1 Answers  

---

Mention the differences between having and where clause.

1 Answers  

---