spAddUpdate_UserPages_PageEditors
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @UserPageID | int | IN | |
| @ClientUserID_CSV | nvarchar(1024) | IN |
Definition
Copy
create procedure dbo.spAddUpdate_UserPages_PageEditors(
@UserPageID int,
@ClientUserID_CSV nvarchar(1024)
)
as
delete from dbo.UserPagesEditors where UserPagesID=@UserPageID;
insert into dbo.UserPagesEditors
select @UserPageID, ID from fnCSVIDsToTable(@ClientUserID_CSV)