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

How to find the version of sql server? : sql server database administration

0 Answers  

How is foreign key related to primary key?

0 Answers  

Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  

Explain nested trigger in sql?

0 Answers  

What is the difference between cartesian product and cross join?

0 Answers  

Do you know what is xpath?

0 Answers  

What is nolock?

0 Answers  

What is a non clustered primary key?

0 Answers  

What action plan is preferred if sql server is not responding?

0 Answers  

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

What is an identity?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories