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

What are the difference between clustered and a non-clustered index?

0 Answers  

Describe the functionalities that views support.

0 Answers  

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

What is an etl file?

0 Answers  

Which are the important points to note when multilanguage data is stored in a table?

0 Answers  

What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

Security Question- SQL DBA exparts, need your help...

3 Answers  

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

What is a filestream?

0 Answers  

Plz tell about backup&recovery?

3 Answers  

How do I know if localdb is running?

0 Answers  

What is data block and how to define data block size?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories