事物 格式 sp

 

GO

/****** Object:  StoredProcedure [dbo].[sp_SHJMEQ_MovieDeliveryManageModifyAll]    Script Date: 05/18/2012 10:28:45 ******/

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:zhanghp -- Create date:2011-12-21 -- Description: <Description,,>

-- =============================================

ALTER PROCEDURE [dbo].[sp_SHJMEQ_MovieDeliveryManageModifyAll]

  -- @变量

AS BEGIN

begin tran

begin try

--sql语句

commit tran

end try

begin catch

rollback tran

end catch

END