Simple Transaction Question...

• rhunt

  SSCertifiable

  Points: 5868

  More actions

  May 6, 2005 at 10:57 am

  #186026

  I rarely right procedures as I typically provide adhoc T-SQL support.  However, that is changing and I am designing more databases, etc.  I have been looking for a quick reference on transactions but haven't found one.  I'm hoping some people on the list might look at the following procedure and provide suggestions on transaction management. In this procedure, the deletes have to happen in the order I've listem them as there are DRI requirements.

  CREATE PROCEDURE dbo.spDeleteLandSites

  (@SiteID uniqueidentifier)

  AS

  SET NOCOUNT ON

  BEGIN

   DELETE FROM dbo.LandSiteImages WHERE SiteID=@SiteID

   DELETE FROM dbo.LandSiteDescriptions WHERE SiteID=@SiteID

   DELETE FROM dbo.LandSites WHERE SiteID=@SiteID

  END

   

  Thanks in advance. RH

  GO

• ChrisMoix-87856

  SSCertifiable

  Points: 7288

  More actions

  May 6, 2005 at 11:05 am

  #557422

  There is a series of articles on this site that provide a good overview of transactions (and performing error checking, rollbacks, etc. inside them). See: http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart1.asp

  http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart2.asp

  http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart3.asp

   

• rhunt

  SSCertifiable

  Points: 5868

  More actions

  May 6, 2005 at 11:08 am

  #557423

  Thanks. RH