SQL Server 2005带事务的存储过程示例[自用标记]

一总

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author:<Author,,Name>
-- Create date: <Create Date,,>
-- Description:<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[ssidb_DeleteDepartment]
@orgID varchar(32)
AS
BEGIN
begin tran TranStart
save tran FirstPoint
update [dbo].[ssidb_Organization]
set [DelFlag]=1
where [ID]=@orgID
update [dbo].[ssidb_Organization]
set [DelFlag]=1
where ID in (
select a.ID from dbo.ssidb_Organization a
, dbo.ssidb_f_cid(@orgID) b
where a.ID = b.ID
)
if @@ERROR <> 0
begin
rollback tran FirstPoint
end
commit tran TranStart
END