QueriesMSSQL (adams-pom 25.9.0-SNAPSHOT API)

java.lang.Object
- adams.db.queries.AbstractDatabaseQueries
- - adams.db.queries.QueriesMSSQL

All Implemented Interfaces:

Serializable
```
public class QueriesMSSQL
extends AbstractDatabaseQueries
```
MSSQL Server queries.

Author:

fracpete (fracpete at waikato dot ac dot nz)

See Also:

Serialized Form

Field Summary
- Fields inherited from class adams.db.queries.AbstractDatabaseQueries
  m_Cache, m_Types

Constructor Summary

Constructors
Constructor Description

QueriesMSSQL()

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`boolean`	`handles(String url)`	Checks whether this URL is handled.
`String`	`limit(int max)`	Generates the row limiting expression.
`String`	`limitKeyword()`	Returns the keyword/expression for limiting the number of rows.
`String`	`regexp(String col, String expr)`	Generates a regexp expression from the column and regular expression.
`String`	`regexpKeyword()`	Returns the keyword for regular expression matching in queries.

Methods inherited from class adams.db.queries.AbstractDatabaseQueries
getHandler, regexp

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - QueriesMSSQL
```
public QueriesMSSQL()
```
- Method Detail
  - regexpKeyword
```
public String regexpKeyword()
```
    Returns the keyword for regular expression matching in queries.
    
    Specified by:
    
    regexpKeyword in class AbstractDatabaseQueries
    
    Returns:
    
    the keyword
  - regexp
```
public String regexp(String col,
                     String expr)
```
    Generates a regexp expression from the column and regular expression.
    
    Overrides:
    
    regexp in class AbstractDatabaseQueries
    
    Returns:
    
    the expression
  - limitKeyword
```
public String limitKeyword()
```
    Returns the keyword/expression for limiting the number of rows.
    
    Specified by:
    
    limitKeyword in class AbstractDatabaseQueries
    
    Returns:
    
    the keyword/expression
  - limit
```
public String limit(int max)
```
    Generates the row limiting expression. NB: requires an ORDER BY in the statement.
    
    Overrides:
    
    limit in class AbstractDatabaseQueries
    
    Parameters:
    
    max - the maximum number of rows to return
    
    Returns:
    
    the expression
  - handles
```
public boolean handles(String url)
```
    Checks whether this URL is handled.
    
    Specified by:
    
    handles in class AbstractDatabaseQueries
    
    Parameters:
    
    url - the URL to check
    
    Returns:
    
    true if handled by this type class