聽說幸福…在山的那邊 (浪機子)

USE [master]
GO

/****** Object:  StoredProcedure [dbo].[sp_exec]    Script Date: 2017/2/18 下午 02:30:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

--@Jason_20170216: 新建立

-- exec [sp_exec] ''

create proc [dbo].[sp_exec]
(
@str varchar(MAX)
)
AS

BEGIN TRY
 PRINT(@str)
 EXEC(@str)

 EXEC master.dbo.sp_BatchLog 0, 0, 'sp_exec', @str
END TRY
BEGIN CATCH
 throw
 GOTO ERROR
END CATCH 

RETURN 0
 
ERROR:
    DECLARE @ErrorMessage NVARCHAR(4000);
 SELECT @ErrorMessage = '執行有誤,'+@str
 
 EXEC master.dbo.sp_BatchLog 0, 0, 'sp_exec', @ErrorMessage
 
    RAISERROR (@ErrorMessage, -- Message text.
               12, -- Severity.
               1 -- State.
               );

 RETURN 9
GO