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

when we use function instead of procedure? plz tell me the
situation with ex?

Answer Posted / manoj

Usually procedures are used when some action is to be
performed without retrun value.
Functions are used when some value is to be returned to the
calling enviornment.
You can not use procedure in the select statement however
functions can be used.

Is This Answer Correct ?    30 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many ways to create table-valued functions?

992


What happens if strings are casted into wrong code pages in ms sql server?

1113


Difference between aggregate functions of sql?

1107


Can we insert data into view sql server?

935


What is transaction server distributed transaction?

1061


What is the syntax for encrypting a column in SQL Server?

1124


What does asynchronous call backs means?

1162


How do you open a cluster administrator?

1054


What are user defined functions in ms sql server?

1003


Does transparent data encryption provide encryption when transmitting data across the network?

1051


Explain what is public role in sql server?

1138


Find columns used in stored procedure?

991


Can we insert data if clustered index is disabled?

943


Explain how many types of relationship?

1031


What is database replication?

1148