module Sequel::JDBC::MSSQL::DatabaseMethods

   # File lib/sequel/adapters/jdbc/mssql.rb
14 def last_insert_id(conn, opts=OPTS)
15   if (stmt = opts[:stmt]) && opts[:prepared]
16     rs = stmt.getGeneratedKeys
17     begin
18       if rs.next
19         begin
20           rs.getLong(1)
21         rescue
22           rs.getObject(1) rescue nil
23         end
24       end
25     ensure
26       rs.close
27     end
28   else
29     statement(conn) do |stmt|
30       sql = 'SELECT SCOPE_IDENTITY()'
31       rs = log_connection_yield(sql, conn){stmt.executeQuery(sql)}
32       rs.next
33       rs.getLong(1)
34     end
35   end
36 end

   # File lib/sequel/adapters/jdbc/mssql.rb
38 def prepare_jdbc_statement(conn, sql, opts)
39   if opts[:type] == :insert
40     conn.prepareStatement(sql, JavaSQL::Statement::RETURN_GENERATED_KEYS)
41   else
42     super
43   end
44 end

   # File lib/sequel/adapters/jdbc/mssql.rb
47 def primary_key_index_re
48   /\Apk__/i
49 end