spDelete_SearchPart

Parameters

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

Definition

Copy



        CREATE PROCEDURE [dbo].[spDelete_SearchPart]
        (
            @PKID int,
               @CurrentUsersID    int
        )
        AS
            declare @Guid uniqueidentifier
            select @Guid = Guid from SearchPart where ID = @PKID

              begin transaction
            DELETE FROM SearchPart where ID = @PKID
            exec spAuditThis @CurrentUsersID, 3, @Guid, 20
              commit transaction