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

What is the difference between a stored procedure and a user
defined function in sql server?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is the difference between a stored procedure and a user defined function in sql server?..

Answer / kumar.t

1. Stored Procedure to return the output parameter.
but function only return single values no output
parameter.

2. Select Clause we cann't use stored procdure. but
fucntion we can use.

3. XMl Clause contain we can use stored procdure. but
function we cann't use.

4. Whenever to execute function at present any error in the
function automatically to exit from the function. but
stored procudure to ignore the error then go to next line.

By
Kumar.T

Is This Answer Correct ?    5 Yes 1 No

What is the difference between a stored procedure and a user defined function in sql server?..

Answer / samant

1.For user defined function one must have to specify it's
return type while in stored procedure it is not mandatory.

2. u can use function in expression but not stored
procedures

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL Server Interview Questions

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

0 Answers   HP,

Determine when an index is appropriate?

0 Answers  

What are the essential components of sql server service broker?

0 Answers  

What is triggers and its types?

0 Answers  

How do you know if sql server is running on your local system?

0 Answers  

Explain about nested stored procedure?

0 Answers  

Explain how dts is used to extract, transform and consolidate data?

0 Answers  

Why use sub query in sql server and list out types of sub queries?

0 Answers  

What are 3 ways to get a count of the number of records in a table?

0 Answers  

What are page splits?

0 Answers  

What is data compression?

0 Answers  

How do I save a stored procedure in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories