# File lib/sequel/adapters/jdbc/mssql.rb 24 def primary_key_index_re 25 /\Apk__/i 26 end
module Sequel::JDBC::MSSQL::DatabaseMethods
Private Instance Methods
Source
# 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
Get the last inserted id using SCOPE_IDENTITY().
Source
Primary key indexes appear to start with pk__ on MSSQL