What is the diff between Static Queries and Dynamic queries
give me some examples
- 2 Answers
- 9821 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
Is it possible to create trigger on views?
What do you mean by collation recursive stored procedure?
How retrieve field names from the table in SQL through JAVA code?
How to create an index on an existing table in ms sql server?
How to use old values to define new values in update statements in ms sql server?
Explain error handling in ssis?
When we should use and scope of @@identity?
What are views in ms sql server?
List the different types of collation sensitivities in sql server?
Explain about protocol layer present in SQL server?
What is the usage of sign function?
How to execute function in stored procedure sql server?
What is filestream?
Does sql server 2000 full-text search support clustering?
What is shared lock?
