spDelete_Clients

Parameters

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

Definition

Copy



CREATE  PROCEDURE dbo.spDelete_Clients
(
        @PKID        int,
        @CurrentUsersID    int
)
AS
    declare @Guid uniqueidentifier

        begin transaction
delete from clients where id=@PKID
/*
        Update Clients set Deleted = 1 where ID = @PKID

        select @Guid = Guid from Clients where ID = @PKID

        exec spAuditThis @CurrentUsersID, 3, @Guid, 9
*/
    commit