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

What is deploy, process and build? : sql server analysis services, ssas

1156


What is the data type of time?

1019


You want to implement the one-to-many relationship while designing tables. How would you do it?

997


Which Model uses the SET concept

1045


What are the dmvs? : sql server database administration

1122


Where is localdb stored?

994


What is cdc in sql server?

1046


What is an sql server agent?

1116


Explain cross join or cartesian product in sql?

930


Do you know what are acid properties of transaction?

1005


sql database suspect We have a sql database that is showing as suspect. How can we recover?

2004


What are the difference between “where” and “having” clause in sql server?

1134


What do you mean by SQL injection attack?

1129


What is an inner join?

1041


What is the syntax to execute the sys.dm_db_missing_index_details?

1077