c# Programming Glossary: item_count
When is it better to write “ad hoc sql” vs stored procedures [duplicate] http://stackoverflow.com/questions/2734007/when-is-it-better-to-write-ad-hoc-sql-vs-stored-procedures simple query like this SELECT ID DESC FROM tblSTUFF WHERE ITEM_COUNT 5 ... will have its execution plan cached. Moreover because.. this ad hoc query SELECT ID DESC FROM tblSTUFF WHERE ITEM_COUNT 23 ... it will be able to use the cached execution plan. Unfortunately.. auto parameterized like SELECT ID DESC FROM tblSTUFF WHERE ITEM_COUNT 5 OR ITEM_COUNT 23 ... it will still be cached by the exact..
|
