USP_FAFMENUDISPLAYCACHE_DELETE

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@USERID int IN
@CONTENTID int IN
@CHANGEAGENTID uniqueidentifier IN

Definition

Copy


create procedure dbo.USP_FAFMENUDISPLAYCACHE_DELETE
(
    @ID uniqueidentifier,
  @USERID int,
  @CONTENTID int,
    @CHANGEAGENTID uniqueidentifier
)
as begin

    set nocount on;

  if @CONTENTID > 0
    delete from dbo.FAFMENUDISPLAYCACHE where CONTENTID = @CONTENTID
  else
    delete from dbo.FAFMENUDISPLAYCACHE where USERID = @USERID

  return 0;
end