spAddUpdate_RoleRefreshLog

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@LogText	ntext	IN
@Status	int	IN
@UserID	int	IN

Definition

Copy


CREATE procedure [dbo].[spAddUpdate_RoleRefreshLog] (
@PKID        int output,
@LogText        ntext,
@Status        int,
@UserID        int
) 
as

begin
    if (@PKID<=0) 
        begin
            insert into RoleRefreshLog
            (
                LogText,
                Status,
                UserID
            )
            values
            (
                @LogText,
                @Status,
                @UserID
            );
            select @PKID = @@Identity;
        end 
    else 
        begin
            update RoleRefreshLog set
                LogText = @LogText,
                Status = @Status,
                UserID = @UserID,
                UpdateDate = GETUTCDATE()
            where 
                ID = @PKID;
        end

    delete from RoleRefreshLog where DATEDIFF(dd, CreateDate, GETUTCDATE()) > 30
end