|
Posted by Ed Murphy on 11/23/06 09:33
kalaivanan wrote:
> how far dynamic query built inside stored procedures is efficient than
> normal queries inside stored procedures.
The issue is caching query plans.
> does dynamic query have advantage over ad hoc queries and in what way.
They're more powerful - if you need it, and if you can afford the
disadvantages.
See http://www.sommarskog.se/dynamic_sql.html for more info.
Navigation:
[Reply to this message]
|