http://blogs.msdn.com/rajandwivedi/archive/2009/04/28/great-debate-store-procedure-vs-dynamic-sql.aspxThis is one of those topics that always generate a lot of heat among developers, architects and DBAs etc. People typically take a very strong stance on one approach over the other. As most of the IT situations, the answer to this question is : “It Depends”.en-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/rajandwivedi/archive/2009/04/28/great-debate-store-procedure-vs-dynamic-sql.aspx#9574337Wed, 29 Apr 2009 00:15:26 GMT91d46819-8472-40ad-a661-2c78acb4018c:9574337Great Debate: Store Procedure vs. Dynamic SQL | Microsoft Share Point<p>PingBack from <a rel="nofollow" target="_new" href="http://microsoft-sharepoint.simplynetdev.com/great-debate-store-procedure-vs-dynamic-sql/">http://microsoft-sharepoint.simplynetdev.com/great-debate-store-procedure-vs-dynamic-sql/</a></p>