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 are the differences between stored procedure and
functions in SQL Server 2000?

Answer Posted / appu

1.we can't call stored procedure inside query instead we can call function inside query.
2.we can't use stored procedure in select statement where as we can use function in select statement.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps to process a single select statement?

930


What is bit data type? What's the information that can be stored inside a bit column?

909


Write a SQL query to delete a table?

1127


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

948


List types of tables in SQL Azure?

126


What is open database communication (odbc)?

1054


Why would you use sql agent?

1254


What is SubQuery in SQL Server 2008

1015


What is the default fill factor value?

1068


Why I am getting this error when dropping a database in ms sql server?

1065


How do you delete duplicate records in sql server?

1043


When do you think a developer should use sql server-based cursors?

1035


What is transactional replication?

952


How to backup SQL Server Reporting Services ?

148


How do you migrate data from mssql server to azure?

165