ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
when we use function instead of procedure? plz tell me the
situation with ex?
 Question Submitted By :: Senthilsjc
I also faced this Question!!     Rank Answer Posted By  
 
  Re: when we use function instead of procedure? plz tell me the situation with ex?
Answer
# 1		 
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 ?    11 Yes 0 No
Manoj
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
is there more the two primary key in a single table? Systematix22
what is diffence between replicaion and logshipping?  1
where do you use Isolations?give me some exmpale?  1
What do u mean by orphan users, how will u list them in the DB IBM2
what are file groups? Evalueserve3
Difference between server.transfer and server.execute method?  1
How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005  2
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?  4
What is the difference between HAVING clause and the WHERE clause?  4
What are primary keys and foreign keys?  3
How to Get the last identity value used  4
Which institute is best for SQL Server 2005 Training?  5
Explain the storage models of OLAP?  1
What is the difference between 2-Tier architecture and 3-Tier architecture Oracle10
How do you fine the performance tunning? Accenture2
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?  1
How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com Oracle18
What are the new features in SQL Server 2005? Emphasis2
what purpose does OPENXML clause have in sql server stored procedure?  1
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX L&T2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com