spDelete_DocUploadPart

Parameters

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

Copy



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

              begin transaction                                                  
            DELETE FROM DocUploadPart where ID = @PKID                         
            if not @Guid is null exec spAuditThis @CurrentUsersID, 3, @Guid, 20
              commit transaction