CREATE PROCEDURE sp_insere_periodico @autor VARCHAR(200), @titulo VARCHAR(200), @periodico VARCHAR(200), @ano VARCHAR(200), @volume VARCHAR(200), @edicao VARCHAR(200), @paginas VARCHAR(200), @comentario VARCHAR(200) AS
BEGIN
    DECLARE @id NUMERIC(10)

    BEGIN TRANSACTION

        SELECT @id = id_publicacao FROM ID_PUBLICACAO
        SELECT @id = @id + 1

        UPDATE ID_PUBLICACAO SET ID_PUBLICACAO = @id

        INSERT INTO DOCUMENTO VALUES (@id, 'proceedings', NULL, NULL)

        INSERT INTO CAMPOS VALUES (@id, 'author', @autor)
        INSERT INTO CAMPOS VALUES (@id, 'title', @titulo)
        INSERT INTO CAMPOS VALUES (@id, 'journal', @periodico)
        INSERT INTO CAMPOS VALUES (@id, 'year', @ano)

        IF @volume IS NOT NULL
            INSERT INTO campos VALUES (@id, 'volume', @volume)

        IF @edicao IS NOT NULL
            INSERT INTO CAMPOS VALUES (@id, 'number', @edicao)

        IF @paginas IS NOT NULL
            INSERT INTO CAMPOS VALUES (@id, 'pages', @paginas)

        IF @comentario IS NOT NULL
            INSERT INTO CAMPOS VALUES (@id, 'note', @comentario)

    COMMIT
END