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...

Difference between Function and Stored Procedure?

Answer Posted / raj..

The difference mejor between procedure and function is that
function must return value. that should be only single and
function can pass any no. parameter but come out only one
value only using return statement.

procedure can pass any parameter and came out any no. of
values there no any RETURN word.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where can you add custom error messages to sql server? : Sql server administration

1120


Explain the different index configurations a table can have?

945


What is a database table?

970


What are the purposes and advantages stored procedure?

959


Explain stored procedure?

1053


Why union all is faster than union?

913


Describe the functionalities that views support.

1099


what are the reporting service components in SSRS?

163


How to define output parameters in stored procedures?

1027


You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

1004


what's the difference between delete table and truncate table commands? : Sql server database administration

981


How can we use ConnectorJ JDBC Driver with MS SQL?

999


How can I create a report based on a query? : sql server management studio

1015


What is an index in sql?

1006


What is normalization? Explain different forms of normalization?

1160