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.

How to use "begin ... End" statement structures in ms sql server?

1 Answers  

---

Plz tell about backup&recovery?

3 Answers  

---

How do I find query history in sql server?

0 Answers  

---

How to override dml statements with triggers?

1 Answers  

---

Explain the microsoft sql server delete command? : SQL Server Architecture

1 Answers  

---

Can foreign key be deleted?

1 Answers  

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

1 Answers   IBM,

---

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

How do you connect 100 files as a flat file sources in one package of SSIS?

2 Answers  

---

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

Explain what is row_number function?

1 Answers  

---