spAddUpdate_Error

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@Type	nvarchar(1024)	IN
@Message	nvarchar(1024)	IN
@StackTrace	ntext	IN
@SERVERNAME	nvarchar(128)	IN
@ADDITIONALINFORMATION	nvarchar(max)	IN
Definition

Copy

                CREATE  PROCEDURE [dbo].[spAddUpdate_Error]
                (
                    @PKID int output,
                    @Type nvarchar(1024),
                    @Message nvarchar(1024),
                    @StackTrace ntext,
                    @SERVERNAME nvarchar(128) = null,
                    @ADDITIONALINFORMATION nvarchar(max) = null
                )
                AS
                BEGIN
                    IF (@PKID<=0) 
                    BEGIN
                        INSERT INTO Error
                        (
                            [Type],
                            [Message],
                            [StackTrace],
                            [SERVERNAME],
                            [ADDITIONALINFORMATION]
                        )
                        VALUES
                        (
                            @Type,
                            @Message,
                            @StackTrace,
                            @SERVERNAME,
                            @ADDITIONALINFORMATION
                        )
                        SELECT @PKID = @@Identity
                    END
                    ELSE 
                        UPDATE Error SET
                            [Type] = @Type,
                            [Message] = @Message,
                            [StackTrace] = @StackTrace,
                            [SERVERNAME] = @SERVERNAME,
                            [ADDITIONALINFORMATION] = @ADDITIONALINFORMATION,
                            [UpdateDate] = getutcdate()
                        WHERE [ID]=@PKID
                END