Is it a good practice to use SQL Server stored procedures for INSERT, UPDATE, and DELETE statements?

  • It is faster than using ADO methods to accomplish the same task.
  • Network traffic can often be reduced because less code generally has to transverse the network.
  • Often, stored procedures can be more efficient than Transact-SQL code sent to SQL Server not encapsulated in a stored procedure.
  • It is often easier to debug and troubleshoot code in a stored procedure than when it is found mingled with code from the front-end application.
  • It is also often much easier to write and maintain Transact-SQL code if it is in a stored procedure than when it is found mingled with code from the front-end application.
  • ]]>

    Leave a comment

    Your email address will not be published.