module Sequel::JDBC::MSSQL::DatabaseMethods

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
14 def last_insert_id(conn, opts=OPTS)
15   statement(conn) do |stmt|
16     sql = opts[:prepared] ? 'SELECT @@IDENTITY' : 'SELECT SCOPE_IDENTITY()'
17     rs = log_connection_yield(sql, conn){stmt.executeQuery(sql)}
18     rs.next
19     rs.getLong(1)
20   end
21 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
24 def primary_key_index_re
25   /\Apk__/i
26 end