How to drop an existing schema in ms sql server?

0 Answers  

---

How do you delete duplicate records in sql server?

0 Answers  

---

how to change column into row in sql

4 Answers   ESS,

---

What are the advantages of having an index on the sql server?

0 Answers  

---

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

---

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  

---

What will be query used to get the list of triggers in a database?

0 Answers  

---

When would you use it?

0 Answers  

---

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

---

how can we know that how many users are connected in perticuler server??????

2 Answers  

---

What are the advantages of mirroring?

0 Answers  

---

Why Master database is required?

0 Answers   Abacus,

---