Paragon Papers and ArticlesFeatures the latest programming and technology related articles from Paragon CorporationChoice Between Stored Procedures, Functions, Views, Triggers, Inline SQL (updated)- November 30, 2005 There has been a lot of debates around when to use stored procedures vs. raw sql. Many purists are vehemently on one side of the fence or the other. Strangely people talk about views to a lesser extent. Stored functions and triggers are almost nonexistent in these debates. In this article we'll try to provide a non-biased outline of the benefits and pitfalls of each approach.http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=28 |