What is the diff between Dynamic queries and static queries
- 1 Answers
- 10431 Views
- CGG, ICS Integrated Computer Solutions, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Explain acid?
What happens to a statement batch if there is a compilation error?
what are triggers? : Sql server database administration
Explain what is lock escalation?
What are .mdf files?
What are parameterized reports?
Describe and explain about SQL native client?
What is sql server locking?
Comment,Datatypes are unlimited
What is inner join in sql server joins?
When to use Inner join & when to use subquery?
How connect excel to sql server?
Differentiate between a primary key and a unique key.
What are the different acid properties?
What are the advantages of using stored procedures in sql server?
