ALTER PROCEDURE sp_get_id_publicacao (@ID NUMERIC (9,0) output) AS

BEGIN TRANSACTION

    IF NOT EXISTS (SELECT 1 FROM ID_PUBLICACAO)
    BEGIN
        INSERT INTO ID_PUBLICACAO VALUES (1)
    END


    SELECT @ID = ID_PUBLICACAO FROM
         ID_PUBLICACAO

    UPDATE ID_PUBLICACAO SET ID_PUBLICACAO = ID_PUBLICACAO + 1

COMMIT


GO