How to generate random numbers with the rand() function in ms sql server?

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  

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  

---

What is the disadvantages of index?

3 Answers   TCS,

---

How to convert a table data in XML format in sql server?

0 Answers  

---

---

Can a table be created inside a trigger?

0 Answers  

---

Can you type more than one query in the query editor screen at the same time?

0 Answers  

---

Explain about temporary stored procedure?

0 Answers  

---

Explain indexes disadvantages?

0 Answers  

---

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

What is default port number for sql server 2000?

0 Answers  

---

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

---