Can a stored procedure call itself, Database Management System

Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?

Yes. Because Transact-SQL supports recursion, you can write kept procedures that call themselves. Recursion can be explained as a method of problem solving wherein the solution is arrived at by repetitively applying it to subsets of the problem. A common application of recursive logic is to perform numeric computations that lend themselves to repetitive evaluation by the same processing steps. Stored procedures are nested when one kept procedure calls another or implements managed code by referencing a CLR routine, type, or aggregate. You can nest kept procedures and managed code references up to 32 levels.

 

Posted Date: 7/10/2013 6:21:19 AM | Location : United States







Related Discussions:- Can a stored procedure call itself, Assignment Help, Ask Question on Can a stored procedure call itself, Get Answer, Expert's Help, Can a stored procedure call itself Discussions

Write discussion on Can a stored procedure call itself
Your posts are moderated
Related Questions
What benefits can a company gain by managing its own information infrastructure and servicea

List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view

Define Physical and Logical independence  Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic

Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)

Explain outer join? Outer Join - If there are any values in one table which do not have corresponding value(s) in the other, in an equi-join which will not be chosen. Such ro

In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Illustrate the Deployment Diagram A deployment diagram shows all nodes on network, their processor execution and interconnections. In a dynamic model, this is used to represen

What are the objectives of query processing?       Ans: The objectives of query processing is to transform a query written in a high level language into a accurate and efficien

Consider the E/R schema with weak entity sets shown below. Come up with the SQL CREATE TABLE statements (with appropriate primary key, unique and foreign key constraints). Include