SQLServerDialect

classin packageklyn.data.sql

public final class SQLServerDialect implements SQLDialect:

SQLServerDialect

All Implemented Interfaces: SQLDialect

Microsoft SQL Server dialect.

dialect = SQLServerDialect()
assert dialect.quoteIdentifier("user") == "[user]"

Properties

Modifier and Type	Member	Description
public readonly property	name `name as String:`	No summary.
public readonly property	supportsFullOuterJoin `supportsFullOuterJoin as Boolean:`	No summary.
public readonly property	supportsRightJoin `supportsRightJoin as Boolean:`	No summary.

Inherited Properties

propertyInherited Properties from SQLDialect: name, supportsFullOuterJoin, supportsRightJoin

Methods

Modifier and Type	Member	Description
public	concatenate `concatenate(left as String, right as String) as String:`	No summary.
public	endsWith `endsWith(value as String, suffix as String) as String:`	No summary.
public	floorDivide `floorDivide(left as String, right as String) as String:`	No summary.
public	length `length(expression as String) as String:`	No summary.
public	paginate `paginate(sql as String, hasOrder as Boolean, offset as Long, limit as Long) as String:`	Applies SQL Server pagination to a generated SELECT statement.
public	parameterMarker `parameterMarker(index as Int) as String:`	No summary.
public	power `power(left as String, right as String) as String:`	No summary.
public	quoteIdentifier `quoteIdentifier(identifier as String) as String:`	No summary.
public	slice `slice(value as String, start as String, length as String = "") as String:`	No summary.
public	startsWith `startsWith(value as String, prefix as String) as String:`	No summary.

Inherited Methods