Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Static Queries and Dynamic queries
give me some examples
- 2 Answers
- 10974 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / praveen
Static queries are the queries we normally use like SELECT *
FROM EMPLOYEE. where as dynamic queries can be built and
executed dynamically. sp_executesql system stored procedure
is used to execute dynamic sql statements.
Eg: sp_executesql N'select * from employee'
dynamic sql queries will take more time to execute when
compared to static queries
| Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
What are the differences between having and where clause.
What is rtm version in sql server?
What are the limitations in ssrs on sql server express edition?
What is dimension table? : sql server analysis services, ssas
How does clustered and non clustered index work?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
Explain encryption of entire databases without the need for application changes in sql server 2008?
Explain candidate key, alternate key, and composite key?
Some queries related to SQL
What are truncate options available in sql server? : sql server database administration
Explain error and transaction handling in sql server?
What are sp_configure commands and set commands?
What are the methods used to protect against sql injection attack?
How to change parameter value inside the report?
