Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

What is the full form of dql?

0 Answers  

---

What is the stored procedure?

0 Answers  

---

What is 2nf normalization?

0 Answers  

---

In what three ways is the return statement used in a stored procedure?

0 Answers  

---

What information is maintained within the msdb database?

0 Answers  

---

create index a on employee(dno) In this,which index was created?

2 Answers  

---

Write a SQL command to insert and update only a particular field?

0 Answers   ADITI,

---

How to modify an existing user defined function?

0 Answers  

---

Where are sql server user names and passwords stored in 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  

---