dynamic query

#1

hi,
how far dynamic query built inside stored procedures is efficient than
normal queries inside stored procedures.
does dynamic query have advantage over ad hoc queries and in what way.

kalai vanan

#2

kalaivanan wrote:

Quote:

how far dynamic query built inside stored procedures is efficient than
normal queries inside stored procedures.

The issue is caching query plans.

Quote:

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.

#3

kalaivanan wrote:

Quote:

hi,
how far dynamic query built inside stored procedures is efficient than
normal queries inside stored procedures.
does dynamic query have advantage over ad hoc queries and in what way.

kalai vanan
If you pass object name as parameters, you have no choice other than

using dynamic sql
Make sure you read the suggested article fully

Madhivanan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

dynamic query

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

dynamic query - 11-21-2006 , 06:07 AM

Re: dynamic query - 11-23-2006 , 03:33 AM

Re: dynamic query - 11-23-2006 , 07:52 AM