Answer / madhu

When one stored procedure calls another stored procedure
(SP) you have what is called stored procedure nesting. We
can have recursive stored procedures upto 32 nest levels.

Answer / lipsa

If a procedure calls itself it is called recursive.
Like if we are calculating the factorial of a number
writing a stored procedure,then there will be recursive
calling of the procedure.

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,

---

What is normalization? Explain different forms of normalization?

0 Answers  

---

Differentiate between mongodb vs. Sql server?

0 Answers  

---

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

---

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 Answers  

---

Can sql server 2016 run on windows 7?

0 Answers  

---

difference between truncate, delete aur drop?

2 Answers  

---

What is local temp table?

0 Answers  

---

What is the function of inner join?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

---