spAddUpdate_EventCalendarView

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@Name	nvarchar(255)	IN
@SiteContentID	int	IN
@Categories	nvarchar(max)	IN

Definition

Copy


CREATE    PROCEDURE [dbo].[spAddUpdate_EventCalendarView]
(
    @PKID            int output,
    @Name            nvarchar(255),
    @SiteContentID        int,
    @Categories        nvarchar(max)
)
AS
set nocount on
begin transaction

if (@PKID<=0)
    begin

        INSERT INTO EventCalendarView
        (
            Name,
            CreateDate,
            SiteContentID,
            Categories
        )

        VALUES
        (
            @Name,
            getutcdate(),
            @SiteContentID,
            @Categories
        )

        SELECT @PKID = @@Identity

    end 
else 
    begin

        UPDATE EventCalendarView SET
            Name             = @Name,
            SiteContentID     = @SiteContentID,
            Categories        = @Categories
        WHERE ID=@PKID

    end

commit transaction