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 is cluster and nin-cluster index?

4 Answers  

What is checkpoint in sql server?

0 Answers  

System requirements for sql server 2005 express edition?

0 Answers  

How to list all login names on the ms sql server?

0 Answers  

What is 5nf in normalization form?

0 Answers  

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

0 Answers  

How to Insert multiple rows with a single insert statement?

0 Answers  

What are approximate numeric data types in ms sql server?

0 Answers  

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

what protocol both networks use? : Sql server database administration

0 Answers  

What is the purpose of optimization?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories