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

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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cached report?

143


What is user defined stored procedures?

946


What is lookup override?

1040


What is sql collation?

1211


can you instantiate a com object by using t-sql? : Sql server database administration

1002


What is an indexing technique?

936


What is difference between cte and view?

917


Can we return Data from 4(more than 1) tables in stored procedure?

1059


What is SQL Azure Firewall?

136


What are the different editions available in sql server 2000?

1052


How to provide login information for a new odbc dsn?

1052


what is denormalization? : Sql server database administration

926


How can we determine what objects a user-defined function depends upon?

1014


What functions can a view be used to performed?

1060


What is acid properties?

1099