See http://msdn.microsoft.com/en-us/library/ms181055.aspx.

The problem with stored procedures is they increase the effort needed to properly manage the database schema.

For small applications the effort is too big when compared with the total development effort.

TODO: gather all stored procedures advantages and find alternative solutions):

– centralized location for all SQL statements (same thing can be obtained by storing the SQL statements in app resources)

– etc

Advertisements