Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the diff between Dynamic queries and static queries

Question Posted / bhaskar


What is the diff between Dynamic queries and static queries ..

Answer / jerry joseph

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 ?    17 Yes 2 No

Post New Answer

More SQL Server Interview Questions

How to rebuild master databse?

0 Answers  

What are transactions in sql?

0 Answers  

What is an inner join?

0 Answers  

how can u get last observation in an unknown dataset ?

0 Answers   Genpact,

What do you need to connect php to sql server?

0 Answers  




Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

Define magic tables in sql server?

0 Answers  

Explain primary key in sql server?

0 Answers  

What is the function of sql server agent windows service?

0 Answers  

What is the partitioning method?

0 Answers  

Explain syntax for dropping triggers?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories