Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

can i write function in stored procedure and stored
procedure in function and nested procedure.Give one example
for each question?

Question Posted / venukumar.coign


can i write function in stored procedure and stored procedure in function and nested procedure.Give..

Answer / dba

You cannot define stored procedures (SP) or user-define
functions (UDF) in a nested fashion. However, you can
execute SPs and UDFs inside of stored procedures. The
nesting is limited to 32 levels deep (A calls B, which calls
C, etc). So if a recursive call is used (A calls A), you
must have some method of stopping before 32 levels is exceeded.

You can call SPs and UDFs from inside of a UDF, but this
ability is quite limited. If a SP has any side effect, it
cannot be called. So, the SP cannot be used to return any
values to the function.

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What are the operating modes in which database mirroring runs?

0 Answers  

What are the different types of replication? How are they used?

3 Answers  

What are synonyms?

0 Answers  

What is the use of floor function in sql server?

0 Answers  

How to find related tables in sql server?

0 Answers  

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 database replicaion? What are the different types of replication you can set up in SQL Server?

3 Answers  

What is SQL Server?

0 Answers   Atos Origin,

What is truncate table?

0 Answers  

How do indexes help, types?

0 Answers  

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  

Display a roll having miminum marks in two subjects?

7 Answers   Patni,

For more SQL Server Interview Questions Click Here
Categories