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 mean by dml?
What is field in algebra?
What is difference between inner join and join?
How to copy the tables, schema and views from one sql server to another?
What is a system database and what is a user database?
What are secondary xml indexes?
What are different type of Collation Sensitivity?
If the job running very slow what is the action you do
What are the filtered indexes?
What are four major operators that can be used to combine conditions on a where clause?
How to connect sql server management studio express to sql server 2005 express?
Do you know the isolation level that sql server support?
What are temporal tables in sql server 2016?
What is BLOCK statements in SQL?
What are the approximate numeric data types?