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

Describe how to use the linked server?

0 Answers  

What is the difference between views and stored procedures? Can we have input parameters for views?

6 Answers  

Why we are using the sql language?. What is the purpose of using this?

2 Answers  

What are types of subqueries?

0 Answers  

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

How to enter comments in transact-sql statements?

0 Answers  

Explain about Normalization?

0 Answers   Infosys,

Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  

When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  

Does sql server use java?

0 Answers  

What is the difference between migration and upgradation in sql server?

0 Answers  

What are the new data types are introduced in sql 2000?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories