module Sequel::JDBC::MSSQL::DatabaseMethods

Database instance methods for MSSQL databases accessed via JDBC.

Constants

ATAT_IDENTITY
PRIMARY_KEY_INDEX_RE
SCOPE_IDENTITY

Private Instance Methods

last_insert_id(conn, opts={}) click to toggle source

Get the last inserted id using SCOPE_IDENTITY().

# File lib/sequel/adapters/jdbc/mssql.rb, line 24
def last_insert_id(conn, opts={})
  statement(conn) do |stmt|
    sql = opts[:prepared] ? ATAT_IDENTITY : SCOPE_IDENTITY
    rs = log_yield(sql){stmt.executeQuery(sql)}
    rs.next
    rs.getInt(1)
  end
end
primary_key_index_re() click to toggle source

Primary key indexes appear to start with pk__ on MSSQL

# File lib/sequel/adapters/jdbc/mssql.rb, line 40
def primary_key_index_re
  PRIMARY_KEY_INDEX_RE
end
schema_parse_table(table, opts={}) click to toggle source

Call the generic JDBC version instead of MSSQL version, since the JDBC version handles primary keys.

# File lib/sequel/adapters/jdbc/mssql.rb, line 35
def schema_parse_table(table, opts={})
  jdbc_schema_parse_table(table, opts)
end