Thursday, November 20, 2008

Sterod Procedures VS Parameterized Queries

TheServerSide Debates: Stored Procedures v Parameterized Queries

A very good debate on the eternal topic of 'Stored Procedures vs. Parameterized Queries'. Here we see different kind of scenarios, usage of sp_executeSQL, query string concatenation, parameterized queries, stored procedures, etc. The comments below the actual articles are more valuable than the article itself.

One of the conclusions that I am looking for at the moment is that for typical CRUD operations, parameterized queries are better and more effective.

No comments: