Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Dynamic queries and static queries
- 1 Answers
- 10917 Views
- CGG, ICS Integrated Computer Solutions, I also Faced
- E-Mail Answers
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 |
Difference between drill down and drill through report.
What are the steps you will take, if you are tasked with securing an SQL Server?
Is null in sql server?
Explain following error properties?
Is port 1433 secure?
What is temporal table?
What is Left Outer Join?
Wht is the difference between stored procedure and trigger
Tell me what is the significance of null value and why should we avoid permitting null values?
How to replace given values with null using nullif()?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What is sql sandbox in sql server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
