spAddUpdate_Notification_SiteContent

CREATE PROCEDURE [dbo].[spAddUpdate_Notification_SiteContent]
    (
    @PKID int output,
    @NotificationID int,
    @SiteContentID int
    )
    AS
    BEGIN
        IF (@PKID<=0) 
        BEGIN
            INSERT INTO Notification_SiteContent
            (
            NotificationID,
            SiteContentID
            )
            VALUES
            (
            @NotificationID,
            @SiteContentID
            )

            SELECT @PKID = @@Identity

        END
        ELSE 

            UPDATE Notification_SiteContent SET
            NotificationID = @NotificationID,
            SiteContentID = @SiteContentID
            WHERE [ID]=@PKID
    END