spDelete_SiteImages

Parameters

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

Definition

Copy


      CREATE     PROCEDURE [dbo].[spDelete_SiteImages]
(
        @PKID        int,
        @CurrentUsersID    int
)
AS
    declare @Guid uniqueidentifier

        begin transaction
delete from siteimages where id=@PKID

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

exec spDelete_ObjectSecurity @Guid

/*
        Update SiteImages set Deleted = 1 where ID = @PKID


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