CREATE PROCEDURE dbo.[Forum_Attachment_Update]
    (
      @AttachmentID INT,
      @FileID INT,
      @PostID INT,
      @UserID INT,
      @LocalFileName NVARCHAR(255),
      @Inline BIT
    )
AS
    DECLARE @@Exists INT
    SET @@Exists = ( SELECT COUNT(FileID)
                     FROM   dbo.Forum_Attachments
                     WHERE  FileID = @FileID
                   )
    -- New
    IF @@Exists = 0
        BEGIN
            INSERT  INTO dbo.Forum_Attachments
                    (
                      [FileID],
                      [PostID],
                      [UserID],
                      [LocalFileName],
                      [Inline]
                    )
            VALUES  (
                      @FileID,
                      @PostID,
                      @UserID,
                      @LocalFileName,
                      @Inline
                    )
        END
    -- Update
    ELSE
        BEGIN
            UPDATE  dbo.Forum_Attachments
            SET     PostID = @PostID,
                    Inline = @Inline
            WHERE   FileID = @FileID
        END

GO