SQL_PROC_MAX_ID

  /* ================================================
 -- ******** LLAMADA

    DECLARE @ID NUMERIC

    --SELECT * FROM tbCargas ORDER BY IDCarga DESC

    EXEC @ID = dbo.MAX_ID 'CARTERA.dbo.tbClientes','IdCliente'

    PRINT @ID

   ================================================ */

    -- DROP PROCEDURE MAX_ID
    CREATE PROCEDURE MAX_ID
        --***>> PARÁMETROS
        @TABLA CHAR(100),
        @COL_ID CHAR(20)

    --RETURNS NUMERIC


    AS
    BEGIN

    --DECLARE @TABLA VARCHAR(50)
    --SELECT @TABLA = 'tbCargas'

    DECLARE @SQL NCHAR(255)
    DECLARE @MaxId NUMERIC

    --SELECT COL_ID = COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME = @TABLA

    SELECT @SQL = 'SELECT @MaxId = MAX(' + @COL_ID + ') FROM ' + @TABLA
    EXECUTE sp_executesql @SQL ,N'@MaxId varchar(30) OUTPUT', @MaxId=@MaxId OUTPUT

    RETURN @MaxId

    --PRINT 'TABLA : ' + @Tabla
    --PRINT 'COLUMNA ID : ' + @@COL_ID
    --PRINT 'SQL : ' + @SQL

    --PRINT 'MAX ID : '  + CONVERT(VARCHAR,@MaxId)

END