Package io.github.torand.fastersql.dialect

Class SqlServerDialect

java.lang.Object
io.github.torand.fastersql.dialect.SqlServerDialect
All Implemented Interfaces:
Dialect
public class SqlServerDialect extends Object implements Dialect
Defines the Microsoft SQL Server SQL dialect.

Row offset clause is supported from SQL Server 2012 onwards Row limit clause is supported from SQL Server 2012 onwards SQL Server has the ROW_NUMBER() function but must be combined with OVER() in this context.

  • Constructor Details

    • SqlServerDialect

      public SqlServerDialect()
      Creates a Microsoft SQL Server Dialect implementation.

  • Method Details

    • getProductName

      public String getProductName()
      Description copied from interface: Dialect
      Gets the name of the RDBMS product associated with this SQL dialect.
      Specified by:
      getProductName in interface Dialect
      Returns:
      the name of the RDBMS product.

    • formatToNumberFunction

      public String formatToNumberFunction(String operand, int precision, int scale)
      Description copied from interface: Dialect
      Returns the 'to_number' function formatted for a specific SQL dialect.
      Specified by:
      formatToNumberFunction in interface Dialect
      Parameters:
      operand - the string expression to be evaluated as a number
      precision - the precision that represents the number of significant digits
      scale - the scale that that represents the number of digits after the decimal point. Must be less than or equal to the precision.
      Returns:
      the 'to_number' function for a specific SQL dialect.

    • formatToCharFunction

      public String formatToCharFunction(String operand, String format)
      Description copied from interface: Dialect
      Returns the 'to_char' function formatted for a specific SQL dialect.
      Specified by:
      formatToCharFunction in interface Dialect
      Parameters:
      operand - the expression to be evaluated as a string
      format - the vendor-specific format mask
      Returns:
      the 'to_char' function for a specific SQL dialect.

    • formatConcatFunction

      public String formatConcatFunction(List<String> operands)
      Description copied from interface: Dialect
      Returns the 'concat' function formatted for a specific SQL dialect.
      Specified by:
      formatConcatFunction in interface Dialect
      Parameters:
      operands - the string expressions to concatenate
      Returns:
      the 'concat' function for a specific SQL dialect.

    • formatLengthFunction

      public String formatLengthFunction(String operand)
      Description copied from interface: Dialect
      Returns the 'length' function formatted for a specific SQL dialect.
      Specified by:
      formatLengthFunction in interface Dialect
      Parameters:
      operand - the string expression to get length of
      Returns:
      the 'length' function for a specific SQL dialect.

    • formatCeilFunction

      public String formatCeilFunction(String operand)
      Description copied from interface: Dialect
      Returns the 'ceil' function formatted for a specific SQL dialect.
      Specified by:
      formatCeilFunction in interface Dialect
      Parameters:
      operand - the numeric expression to get ceiling of
      Returns:
      the 'ceil' function for a specific SQL dialect.

    • formatLnFunction

      public String formatLnFunction(String operand)
      Description copied from interface: Dialect
      Returns the 'ln' function formatted for a specific SQL dialect.
      Specified by:
      formatLnFunction in interface Dialect
      Parameters:
      operand - the numeric expression to get natural logarithm of
      Returns:
      the 'ln' function for a specific SQL dialect.

    • formatRoundFunction

      public String formatRoundFunction(String operand)
      Description copied from interface: Dialect
      Returns the 'round' function formatted for a specific SQL dialect.
      Specified by:
      formatRoundFunction in interface Dialect
      Parameters:
      operand - the numeric expression to perform rounding on
      Returns:
      the 'round' function for a specific SQL dialect.

    • formatModuloFunction

      public String formatModuloFunction(String divisor, String dividend)
      Description copied from interface: Dialect
      Returns the 'mod' function formatted for a specific SQL dialect.
      Specified by:
      formatModuloFunction in interface Dialect
      Parameters:
      divisor - the numeric expression for divisor operand
      dividend - the numeric expression for dividend operand
      Returns:
      the 'mod' function for a specific SQL dialect.

    • formatCurrentDateFunction

      public String formatCurrentDateFunction()
      Description copied from interface: Dialect
      Returns the 'current_date' system function formatted for a specific SQL dialect.
      Specified by:
      formatCurrentDateFunction in interface Dialect
      Returns:
      the 'current_date' function for a specific SQL dialect.

    • getDataType

      public Optional<String> getDataType(DataType dataType)
      Description copied from interface: Dialect
      Returns the data type for a specific SQL dialect.
      Specified by:
      getDataType in interface Dialect
      Parameters:
      dataType - the ISO data type
      Returns:
      the data type for a specific SQL dialect.

    • getConcatOperator

      public Optional<String> getConcatOperator()
      Description copied from interface: Dialect
      Returns the string concatenation operator for a specific SQL Dialect.
      Specified by:
      getConcatOperator in interface Dialect
      Returns:
      the string concatenation operator for a specific SQL Dialect.

    • supports

      public boolean supports(Capability capability)
      Description copied from interface: Dialect
      Indicates whether a capability is supported by a specific SQL dialect.
      Specified by:
      supports in interface Dialect
      Parameters:
      capability - the capability to check support for
      Returns:
      true if specified capability is supported; else false