spDelete_ClientEvents

Parameters

Parameter Parameter Type Mode Description
@PKID int IN
@CurrentUsersID int IN

Definition

Copy



CREATE    procedure spDelete_ClientEvents
            (
                @PKID int,
                @CurrentUsersID    int

            )
            as
                declare @Guid uniqueidentifier

                begin transaction
delete from clientevents where id=@PKID
/*
                    Update ClientEvents
                        set Deleted = 1
                        where Id = @PKID

                    select @Guid =Guid from ClientEvents where id = @PKID

                    exec spAuditThis @CurrentUsersID, 3, @Guid, 16
*/
                commit transaction