spAddUpdate_ClientUserReport
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @ClientUsersID | int | IN | |
| @SiteContentID | int | IN | |
| @CustomXML | ntext | IN |
Definition
Copy
CREATE PROCEDURE dbo.spAddUpdate_ClientUserReport
(
@PKID int output,
@ClientUsersID int,
@SiteContentID int,
@CustomXML nText
)
AS
begin transaction
if (@PKID<=0)
begin
INSERT INTO ClientUserReport
(
ClientUsersID,
SiteContentID,
CustomXML
)
VALUES
(
@ClientUsersID,
@SiteContentID,
@CustomXML
)
SELECT
@PKID = @@Identity
end else begin
UPDATE ClientUserReport SET
ClientUsersID = @ClientUsersID,
SiteContentID = @SiteContentID,
CustomXML = @CustomXML
WHERE ID=@PKID
end
commit transaction