October 23, 2002 at 12:16 pm
Will stored procedures with dynamic sql in them recompile each time they are called?
October 23, 2002 at 1:24 pm
I know the statement will be recompiled, but not sure about the procedure. Will try to test.
Steve Jones
October 23, 2002 at 1:33 pm
how are you testing this?
October 23, 2002 at 2:20 pm
The stored procedure won't be re compiled on the basis of the dynamic sql.
And the dyanmic SQL might not be re compiled either if you are using sp_executesql and using parameters for your values.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply