Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
suriyarupa
Starting Member
19 Posts |
Posted - 2013-03-13 : 06:34:25
|
Dynamic query will take time to execute? What is the difference between Select query inside Query string and outside of Query string? Which one will take time to execute.? |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-13 : 06:41:08
|
depends on the query always. Cant say always dynamic will take time or vice versa. One thing to note is dynamic sql using sp_executesql will have ability to cache plans as against ones using EXEC()------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
suriyarupa
Starting Member
19 Posts |
Posted - 2013-03-14 : 03:39:40
|
Thanks for ur reply. So you mean to say,If query has been written by using SP_ExecuteSQL command,then it will take time to execute. |
|
|
|
|
|