spAddUpdate_NewsChannels

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@Title	nvarchar(510)	IN
@LinkURL	nvarchar(2048)	IN
@Description	nvarchar(1024)	IN
@Copyright	nvarchar(510)	IN
@EditorEMail	nvarchar(510)	IN
@SiteImageID	int	IN
@ImageTitle	nvarchar(510)	IN
@ImageLink	nvarchar(2048)	IN
@Guid	uniqueidentifier	IN
@SiteContentID	int	IN
@AllowMembers	bit	IN
@PersonalPageDataID	int	IN
@Moderated	bit	IN

Definition

Copy



CREATE    PROCEDURE [dbo].[spAddUpdate_NewsChannels]
(
    @PKID                int output        ,
    @Title                nvarchar(510)    ,
    @LinkURL            nvarchar(2048)    ,
    @Description        nvarchar(1024)    ,
    @Copyright            nvarchar(510)    ,
    @EditorEMail        nvarchar(510)    ,
    @SiteImageID        int                ,
    @ImageTitle            nvarchar(510)    ,
    @ImageLink            nvarchar(2048)    ,
    @Guid                uniqueidentifier,
    @SiteContentID        int,
    @AllowMembers        bit,
    @PersonalPageDataID int,
    @Moderated            bit
)
AS
BEGIN
    set nocount on

    begin transaction

    if (@PKID<=0)

    begin

        INSERT INTO NewsChannels
        (
        Title            ,
        LinkURL            ,
        Description        ,
        Copyright        ,
        EditorEMail        ,
        SiteImageID        ,
        ImageTitle        ,
        ImageLink        ,
        Guid            ,
        SiteContentID        ,
        AllowMembers        ,
        PersonalPageDataID,
        Moderated
        )

        VALUES
        (
        @Title            ,
        @LinkURL        ,
        @Description    ,
        @Copyright        ,
        @EditorEMail    ,
        @SiteImageID    ,
        @ImageTitle        ,
        @ImageLink        ,
        @Guid            ,
        @SiteContentID        ,
        @AllowMembers        ,
        @PersonalPageDataID,
        @Moderated
        )

        SELECT @PKID = @@Identity

    end 
    else 
    begin

        UPDATE NewsChannels SET
            Title            =@Title            ,
            LinkURL            =@LinkURL        ,
            Description        =@Description    ,
            Copyright        =@Copyright        ,
            EditorEMail        =@EditorEMail    ,
            SiteImageID        =@SiteImageID    ,
            ImageTitle        =@ImageTitle    ,
            ImageLink        =@ImageLink        ,
            Guid            =@Guid            ,
            SiteContentID    =@SiteContentID            ,
            AllowMembers   =@AllowMembers            ,
            PersonalPageDataID = @PersonalPageDataID,
            Moderated = @Moderated
        WHERE ID=@PKID

    end

    commit transaction
END