Method applyTopToQuery

src/utils/sql-row-limiter.ts:92–103

* Add or modify TOP clause in a SQL statement (SQL Server)

(sql: string, maxRows: number)

   * Add or modify TOP clause in a SQL statement (SQL Server)
   */
  static applyTopToQuery(sql: string, maxRows: number): string {
    const existingTop = this.extractTopValue(sql);
    
    if (existingTop !== null) {
      // Use the minimum of existing top and maxRows
      const effectiveTop = Math.min(existingTop, maxRows);
      return sql.replace(/\bselect\s+top\s+\d+/i, `SELECT TOP ${effectiveTop}`);
    } else {
      // Add TOP clause after SELECT
      return sql.replace(/\bselect\s+/i, `SELECT TOP ${maxRows} `);
    }
  }

  /**
   * Check if a LIMIT clause uses a parameter placeholder (not a literal number).