Function Database_super_sqlserver->apply_sql_limit_clause

Definitions

sources/database/shared/sqlserver.php

  • Adjust an SQL query to apply offset/limit restriction.
  • Visibility: public
  • Is abstract?: No
  • Is static?: No
  • Is final?: No

Parameters

Name Type Passed by reference? Variadic? Default Set Range Description
&$query string Yes No required parameter N/A N/A The complete SQL query
$max ?integer No No Null N/A N/A The maximum number of rows to affect (null: no limit)
$start integer No No 0 N/A N/A The start row to affect

Preview

Code (PHP)

/**
 * Adjust an SQL query to apply offset/limit restriction.
 *
 * @param  string $query The complete SQL query
 * @param  ?integer $max The maximum number of rows to affect (null: no limit)
 * @param  integer $start The start row to affect
 */

public function apply_sql_limit_clause(string &$query, ?int $max = null, int $start = 0)