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

diffrence between function and procedure

Answer Posted / srinivas k

Function should always return a value, where as Store Proc
may or may not return values.
Functions can be part of DML statements, where SP cannot be.
SP are precompiled and functions are not.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how to maintain a fill factor in existing indexes?

994


What is tcl in sql server?

1122


What protocol does sql server use?

941


what is dbcc? : Sql server database administration

1028


Do you know hot add cpu in sql server 2008?

952


What is user-defined inline table-valued function?

946


What is difference between joins and subqueries?

1117


How do you improve the performance of a SQL Azure Database?

137


explain databases and sql server databases architecture? : Sql server database administration

957


What do we need queues in sql service broker?

1065


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

1076


Can we perform backup restore operation on tempdb?

1006


How to find the second highest salary of an employee?

1172


What is the Difference Between Primary and Foreign Key?

1006


Explain cdc and sql injection?

976