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
- 10745 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 is filter index?
What is Federation and Federation Member?
How can change procedure in sql server?
How to write a query with a full outer join in ms sql server?
How to name query output columns in ms sql server?
How to concatenate two character strings together?
Why use triggers?
Explain the truncate command?
What is a trace frag?
1 01 101 01010
How to create a new login name in ms sql server?
Is sql server a database?
What do you mean by table and field in sql?
How do I perform an unattended install of sql server 2000?
How dts is used to extract, transform and consolidate data?
