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