存储过程转换,急求高手帮助!谢谢!!
幸福树 2011-09-27 01:59:00 SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[sp_update_cms_contract_nstc_interface]
AS
declare @errorvariable int
BEGIN
SET XACT_ABORT ON
BEGIN TRY
BEGIN TRAN T1
--更新零售合同信息
delete IF_Contract
insert into IF_Contract
select * from [10.192.68.177].[EsApp].[dbo].[NSTC_IF_Contract_T]
COMMIT TRAN T1
END TRY
BEGIN CATCH
set @errorvariable=@@ERROR
IF @errorvariable<>0
BEGIN
ROLLBACK TRAN T1
RETURN
END
END CATCH
END