Kenneth Gartner thinks this is interesting: when the parameters used by the stored procedure are volatile. From Chapter 8. Stored Procedures and User-Defined Functions from Microsoft® SQL Server® 2012: A Beginner’s Guide, Fifth Edition by Dusan Petkovic Publisher: McGraw-Hill Released: March 2012 Note What does volatile mean in this context? Share this highlight http://www.safaribooksonline.com/a/microsoft-sql-server/9501752/ Twitter Facebook Google Plus Email Get Instant Access Now Start a Free Trial Have an account? Sign in. Minimise Unlock the rest of this book and 30,000 other books and videos By clicking this box, you confirm that you have read and agree to the terms and conditions of our Membership Agreement, and you understand that when your trial period ends, you will be required to provide billing information if you wish to continue using the service. Unlock the rest of this book Start a Free 10-Day Trial loading Learn about Safari for Business Have an account? Sign in.