This post originated from an RSS feed registered with .NET Buzz
by douglas reilly.
Original Post: Stored Procedures vs. Ad Hoc SQL Article online...
Feed Title: Doug Reilly's Weblog
Feed URL: http://www.asp.net/err404.htm?aspxerrorpath=/dreilly/rss.aspx
Feed Description: ASP.NET and More...
I have a new article posted online at Red Gate's site, discussing the SQL Server vs. Ad Hoc SQL debate. It covers, point by point, the arguments I have heard for and against using Stored Procedures on Microsoft SQL Server, and rates them as I see them. The most important point is that security against SQL Injection attacks can be had without requiring use of Stored Procedures, though there are some other reasons you might want to use them.