Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Dynamic queries and static queries
- 1 Answers
- 10912 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
Is BCNF better than 2NF & 3NF? Why?
what are constraints? : Sql server database administration
What is the difference between a stored procedure and a user defined function?
What are the recovery models in sql server 2000?
What do you understand by check constraint in sql server?
Describe and explain about SQL native client?
List out different types of normalizations in sql server and explain each of them?
What is a join in sql? What are the types of joins?
How can you list all the table constraints in a database?
What are commit and rollback in sql?
What is the report builder?
Explain filtered indexes?
What is cte (common table expression)?
How to list all objects in a given schema?
What are dml (data manipulation language) statements in ms sql server?
