# File lib/sequel/adapters/jdbc/mssql.rb, line 24 def primary_key_index_re /\Apk__/ end
Get the last inserted id using SCOPE_IDENTITY().
# File lib/sequel/adapters/jdbc/mssql.rb, line 14 def last_insert_id(conn, opts=OPTS) statement(conn) do |stmt| sql = opts[:prepared] ? 'SELECT @@IDENTITY' : 'SELECT SCOPE_IDENTITY()' rs = log_connection_yield(sql, conn){stmt.executeQuery(sql)} rs.next rs.getLong(1) end end
Primary key indexes appear to start with pk__ on MSSQL
# File lib/sequel/adapters/jdbc/mssql.rb, line 24 def primary_key_index_re /\Apk__/ end