Well written.. especially, the misconception of caching related advantages is removed now.But one more reason I feel to use Stored Procs over simple SQL statements because of SQL Injection.. i mean, simple SQL statements are vulnerable to SQL Injection

Subscription Package for fundamentals and Interview preparation

which consist of .NET, C#, ASP.NET, SQL Server, WCF, Design Patterns, SilverLight, LINQ, SharePoint, Azure videos read details of subscription Also want to inquire more then call us on +91-22-66752917/mail us on questpond@questpond.com. Simply click to .