spAddUpdate_PersonalPageData

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@ElementID	int	IN
@ParentID	int	IN
@ParentType	int	IN
@XMLData	ntext	IN
@UserPersonalPageID	int	IN

Definition

Copy



        CREATE  PROCEDURE [dbo].[spAddUpdate_PersonalPageData]
(
    @PKID            int output,
    @ElementID        int,        
    @ParentID         int,
    @ParentType        int,
    @XMLData        ntext,
    @UserPersonalPageID int
)
AS

    begin transaction
    if (@PKID<=0)
        begin

        INSERT INTO PersonalPageData
        (
            ElementID    ,
            ParentID    ,
            ParentType    ,
            [XMLData]    ,
            UserPersonalPageID
        )VALUES(
            @ElementID    ,
            @ParentID    ,
            @ParentType    ,
            @XMLData    ,
            @UserPersonalPageID
        ) 

        SELECT
            @PKID = @@Identity

    end else begin

        UPDATE PersonalPageData SET
            ElementID    =@ElementID    ,
            ParentID    =@ParentID    ,
            ParentType    =@ParentType,
            [XMLData]    =@XMLData    ,
            UserPersonalPageID =@UserPersonalPageID

        WHERE ID=@PKID

    end

    commit transaction