How to drop an existing table?

0 Answers  

---

What are the steps you will take to improve the performance of a poor performing query?

0 Answers  

---

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  

---

List out a number of the wants to setup a SQL Server failover cluster?

0 Answers  

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

---

---

What do you mean by authentication modes in sql server?

0 Answers  

---

What is the purpose of optimization?

0 Answers  

---

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---

What is the difference between for trigger and after trigger?

0 Answers  

---

What is change tracking in sql server?

0 Answers  

---

Tell me what are the essential components of sql server service broker?

0 Answers  

---

How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

---