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.?
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 MVP http://visakhm.blogspot.com/
Dynamic Query
Posted - 03/13/2013 : 06:34:25
