>Hello,
>I am trying to find a simple example of a transaction. I have 2 delete statements that I want to put in the same SP, but I either want it all to work or none of it to work.
>
>I tried googling but it's hard to find a simple example.
>
>Thanks a lot,
>MAC


Here is some code I have in an SP:

BEGIN TRANSACTION

DELETE FROM ProgramHdr 
WHERE ControlId = @ControlId
			
IF @@ERROR <> 0
BEGIN
  SET @OriginalError = @@ERROR
  RAISERROR ('Delete Error: ProgramHdr table. Error: %o.', 16, 1, @@ERROR)
  ROLLBACK TRANSACTION
  RETURN @OriginalError
END

DELETE FROM ProgramDtl 
WHERE ControlId = @ControlId
			
IF @@ERROR <> 0
BEGIN
  SET @OriginalError = @@ERROR
  RAISERROR ('Delete Error: ProgramDtl table. Error: %o.', 16, 1, @@ERROR)
  ROLLBACK TRANSACTION
  RETURN @OriginalError
END

-- At this point all rows should be deleted and it is safe to commit the transaction
COMMIT TRANSACTION

Hope this helps