Monday, 14 January 2008

Stored Procedures - Reasons to use/not use them

Some reasons to use/not use stored procedures found from doing a bit of googling..

Reasons to use them

  • Your organization's DBAs won't give users or applications SELECT privileges on production SQL Server tables.
  • Stored procedures result in easier maintenance because it is generally easier to modify a stored procedure than it is to change a hard-coded SQL statement within a deployed coponent.
  • Stored procedures add an extra level of abstraction from the underlying database schema. The client of the stored procedure is isolated from the implementation details of the stored procedure and from the underlying schema.
Reasons not to use them

  • LINQ

No comments: