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 Procedure and Function

Question Posted / khaleek.ahmad

Answers were Sorted based on User's Feedback



What is the difference between Procedure and Function..

Answer / devanand

procedure can not return tye but fuction must a return type

Is This Answer Correct ?    25 Yes 1 No

What is the difference between Procedure and Function..

Answer / paporirokz

A function can return a value whereas a procedure cannot
return a value.

Is This Answer Correct ?    17 Yes 6 No

What is the difference between Procedure and Function..

Answer / satbir singh jawla

according to the prodedure is mainly use in those language
that does not support the object so it does not give the
return type value whereare function mainly use in object
oriented language so it give the return type value some thing.

Is This Answer Correct ?    2 Yes 0 No

What is the difference between Procedure and Function..

Answer / khaleek.ahmad

9.There is possible of recursive function like
max(min(something)),but there is nothing like in procedure.

10.We can call a function from a procedure, but it is not
possible to call a procedure from a function

For more detail , please see at.
http://interview-preparation-for-you.blogspot.com/2010/05/difference-between-function-and.html

Is This Answer Correct ?    3 Yes 10 No

Post New Answer

More SQL Server Interview Questions

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

How to list all columns in a table using odbc_columns()?

0 Answers  

Can binary strings be used in arithmetical operations?

0 Answers  

How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

What is a Join and explain its types?

0 Answers  

What are the type of Indexes? which one is best, why?

6 Answers  

What are pages and extents? : SQL Server Architecture

0 Answers  

What are the indexes in sql server?

0 Answers  

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

0 Answers  

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

For more SQL Server Interview Questions Click Here
Categories