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

What are the advantages of paper records?

0 Answers  

How to maintain a fill factor in existing indexes?

0 Answers  

Explain what is lock escalation?

0 Answers  

What is a hint?

0 Answers  

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

Can we install sql server 2016 on windows 7?

0 Answers  

How to connect ms access to sql servers through odbc?

0 Answers  

Explain nested join?

0 Answers  

How can you list all the columns in a database?

0 Answers  

What is not null constraint?

0 Answers  

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

0 Answers  

What is a collation in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories