# File lib/sequel/adapters/jdbc/mssql.rb, line 30 def primary_key_index_re PRIMARY_KEY_INDEX_RE end
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=OPTS)
click to toggle source
Get the last inserted id using SCOPE_IDENTITY().
# File lib/sequel/adapters/jdbc/mssql.rb, line 20 def last_insert_id(conn, opts=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