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
What is the diff between Dynamic queries and static queries
 Question Submitted By :: Bhaskar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the diff between Dynamic queries and static queries
Answer
# 1
Static query will be executed as it is.

Dynamic query is built upon conditions depending upon the
parameters.

Static query will create an execution plan during compilation.

Dynamic query will create execution plan at run time.
Its very slow in execution since building the plan at run
time makes it too slow.
 
Is This Answer Correct ?    5 Yes 0 No
Jerry Joseph
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
what is trigger NIIT1
What is INTVAL( )and where we use Plz any body help me  1
What value could be assigned to Varchar Type?  3
what is the maximum size of a row in sql server 2000 and 2005  2
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.  7
how to generate XML out of QUERY? McAfee1
from the table display the 2nd highest salary? and also the least 2nd salay?  6
Display a roll having miminum marks in two subjects? Patni7
What is row by row processing ?  1
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.  1
what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1; Patni9
About types of indexes in SQL server ? Cognizent1
What is a stored procedure?  3
hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000  3
can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?  1
What is SQL server agent? SAP-Labs2
What is SQL Profiler what is the use of it? 247Customer2
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table? eFunds5
what is the signification difference of this bit data type between sql 6.5 and later version sql server?  1
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?  2
 
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