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