What is the diff between Static Queries and Dynamic queries
give me some examples
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 is data file in computer?
What is the sql server 2000 version number?
What is the bookmark lookup and rid lookup?
What action plan is preferred if sql server is not responding?
How do database indexes work?
What is dbcc? Give few examples.
What will be the maximum number of index per table?
If we delete pack Spec what will be the status of pack Body ?
what are different types of backups available in sql server? : Sql server database administration
what is memory-optimized nonclustered indexes
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is the purpose of a table?
what types of replication are supported in sql server? : Sql server database administration
Introduction of rollup clause using sum and group by clause?
What are different types of views?