RE: How to write SQL queries

regarding the statement “Wherever possible, use Prepared Statements” in the article How to write SQL queries correctly, I can say the following: Performance of stored procedures MS SQL Server 2000
In general, code caching is not always good.