@staticmethod
def id_next(con_db, table, schema, id_col, print_sql=False):
    """
        This static method returns the next id to be inserted into a table for sql_server
        :param con_db: class to connect to a sql server dabatase
        :param table: name of the table
        :param schema: name of the schema
        :param id_col: name of the id column
        :param print_sql: bool to indicate if you want sql statement to be print on Python Console
        :return: Max ID + 1 for id_col
        """
    sql_statement = (
        'SELECT CASE WHEN MAX(%s) IS NULL THEN 1 ELSE MAX(%s) + 1 END AS [Id] FROM [%s].[%s]'
         % (id_col, id_col, schema, table))
    if print_sql:
        print(sql_statement)
    df = con_db.query(sql_statement)
    id = df.loc[0, 'Id']
    return id
