Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---

How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  

---

 Explain what is sql override for a source taLle in a mapping?

0 Answers   Informatica,

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

Can sql servers link to other servers?

0 Answers  

---

---

What is mssql?

0 Answers  

---

What is truncate table?

0 Answers  

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

What is db stored procedure?

0 Answers  

---

What are the different index configurations a table can have?

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  

---

What is right outer join in sql server joins?

0 Answers  

---