LimitClauseKind.Type describes the type of limit clause supported by the SQL dialect used by this data source.
Enumeration Options
Enumerations simplify the process of selecting options within a function. To specify the LimitClauseKind.Type, users have the option to either input the below Argument description (which provides more information) or the shorter Value (which provides a more concise representation).
| Argument | Value | Description |
|---|---|---|
| LimitClauseKind.None | 0 | This SQL dialect does not support a limit clause. |
| LimitClauseKind.Top | 1 | This SQL dialect supports a TOP specifier to limit the number of rows returned. |
| LimitClauseKind.LimitOffset | 2 | This SQL dialect supports LIMIT and OFFSET specifiers to limit the number of rows returned. |
| LimitClauseKind.Limit | 3 | This SQL dialect supports a LIMIT specifier to limit the number of rows returned. |
| LimitClauseKind.AnsiSql2008 | 4 | This SQL dialect supports an ANSI SQL-compatible LIMIT N ROWS specifier to limit the number of rows returned. |
The enumerations belonging to LimitClauseKind.Type are currently only supported by the Odbc.DataSource function. You can select them by choosing ODBC as data source, and then choosing your desired option in the below pop-up.
Applies to
Here’s a list of functions that work with LimitClauseKind.Type:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy