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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / senthilsjc

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / priya

can we use default value in unique key?

Is This Answer Correct ?    4 Yes 2 No

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

Answer / adil khan

procedure can only use in plsql not in sql. in other words
you can not use procedure in your select satatement. only
funtion can be used for example max(),min(),Avg() these all
are funtion not procedure.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Tell me when is the update_statistics command used?

0 Answers  

Which is the main third-party tool used in sql server?

0 Answers  

What are binary string data types in ms sql server?

0 Answers  

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

What is self contained sub query?

0 Answers  

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

What is log ldf?

0 Answers  

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

What is RMS migrations?

0 Answers   Satyam,

what is advantages in sql 2005 over sql 2000?

4 Answers  

Mention the differences between local and global temporary tables.

0 Answers  

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories