What is “asynchronous” communication in sql server service broker?

0 Answers  

---

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  

---

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

how many no of arguments can be passed in procedures and functions

1 Answers   ABC,

---

We need to perform what steps in the following order to work with a cursor?

0 Answers  

---

What are the advantages of the mirroring?

0 Answers  

---

What are policy management terms?

0 Answers  

---

What happens if null values are involved in boolean operations?

0 Answers  

---

What is row-level compre?

0 Answers  

---

What to perform pattern match with the like operator?

0 Answers  

---

what is normalization? what is denormalization?

9 Answers   Satyam,

---