spAddUpdate_ClientUserCalendarFilters
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @UserID | int | IN | |
| @SiteContentID | int | IN | |
| @FilterOptions | varchar(max) | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spAddUpdate_ClientUserCalendarFilters](
@UserID int,
@SiteContentID int,
@FilterOptions varchar(max)
)
AS
set nocount on
begin
delete from dbo.ClientUserCalendarFilters
where UserID = @UserID and SiteContentID = @SiteContentID
insert into dbo.ClientUserCalendarFilters (UserID, SiteContentID, FilterOptions)
values (@UserID, @SiteContentID, @FilterOptions)
end