Contents

1


1 #

create proc [ろる].usp_[企覈]_[crud]_[襦覈] --麹 曙企ゼ る ..
    @朱誤1 [datetype]
,   @朱誤2 [datetype]
,   @朱誤n [datetype]
/*
  : 2007-11-26
  : 伎
    覈:
朱誤: 
    - 

    - 豢

伎:

        伎
----------  ------  --------------------------------------------------------------
2007-11-26  伎  豕豐覯
*/
--with execute as (蟠, 貎朱Μろ襷 ,  譯殊豌襴)
as 

set lock_timeout 3000
set xact_abort on 
set nocount on 

begin try
    begin tran;

    --SP伎 蠍一..

    commit;
    return 0;
end try

begin catch
    if      (xact_state()) = -1 rollback; 
    else if (xact_state()) =  1 commit;

    insert dbo.t_sp_errorlog
    (
        err_number
    ,   err_severity
    ,   err_state
    ,   err_procedure
    ,   err_line
    ,   err_message
    ,   err_datetime
    ,   parameters
    )
    select
        error_number()       as err_number     -- int
    ,   error_severity()    as err_severity    -- int
    ,   error_state()       as err_state       -- int
    ,   error_procedure()   as err_procedure   -- nvarchar(126)
    ,   error_line()        as err_line        -- int
    ,   error_message()     as err_message     -- nvarchar(2048) 
    ,   getdate()           as err_datetime    -- datetime
    ,   convert(nvarchar(200), @朱誤1)
        + ',' + convert(nvarchar(200), @朱誤2)
        + ',' + convert(nvarchar(200), @朱誤n)

    return error_number();
end catch;

/*
--襾殊  企 焔 伎 .
create table [ろる].[t_sp_errorlog](
    [err_number] [int] null,
    [err_severity] [int] null,
    [err_state] [int] null,
    [err_procedure] [nvarchar](126) null,
    [err_line] [int] null,
    [err_message] [nvarchar](2048) null,
    [err_datetime] [datetime] null,
    [parameters] [nvarchar](max) null
);
*/