Module Sequel::MSSQL::DatabaseMethods
In: lib/sequel/adapters/shared/mssql.rb

Methods

database_type   server_version   supports_savepoints?   supports_transaction_isolation_levels?   tables   views  

Constants

AUTO_INCREMENT = 'IDENTITY(1,1)'.freeze
SERVER_VERSION_RE = /^(\d+)\.(\d+)\.(\d+)/.freeze
SERVER_VERSION_SQL = "SELECT CAST(SERVERPROPERTY('ProductVersion') AS varchar)".freeze
SQL_BEGIN = "BEGIN TRANSACTION".freeze
SQL_COMMIT = "COMMIT TRANSACTION".freeze
SQL_ROLLBACK = "IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION".freeze
SQL_ROLLBACK_TO_SAVEPOINT = 'IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION autopoint_%d'.freeze
SQL_SAVEPOINT = 'SAVE TRANSACTION autopoint_%d'.freeze
DECIMAL_TYPE_RE = /number|numeric|decimal/io   The types to check for 0 scale to transform :decimal types to :integer.

Attributes

mssql_unicode_strings  [RW]  Whether to use N’’ to quote strings, which allows unicode characters inside the strings. True by default for compatibility, can be set to false for a possible performance increase. This sets the default for all datasets created from this Database object.

Public Instance methods

database_type()

Microsoft SQL Server uses the :mssql type.

[Source]

    # File lib/sequel/adapters/shared/mssql.rb, line 25
25:       def database_type
26:         :mssql
27:       end
server_version(server=nil)

The version of the MSSQL server, as an integer (e.g. 10001600 for SQL Server 2008 Express).

[Source]

    # File lib/sequel/adapters/shared/mssql.rb, line 31
31:       def server_version(server=nil)
32:         return @server_version if @server_version
33:         @server_version = synchronize(server) do |conn|
34:           (conn.server_version rescue nil) if conn.respond_to?(:server_version)
35:         end
36:         unless @server_version
37:           m = SERVER_VERSION_RE.match(fetch(SERVER_VERSION_SQL).single_value.to_s)
38:           @server_version = (m[1].to_i * 1000000) + (m[2].to_i * 10000) + m[3].to_i
39:         end
40:         @server_version
41:       end
supports_savepoints?()

MSSQL supports savepoints, though it doesn‘t support committing/releasing them savepoint

[Source]

    # File lib/sequel/adapters/shared/mssql.rb, line 44
44:       def supports_savepoints?
45:         true
46:       end
supports_transaction_isolation_levels?()

MSSQL supports transaction isolation levels

[Source]

    # File lib/sequel/adapters/shared/mssql.rb, line 49
49:       def supports_transaction_isolation_levels?
50:         true
51:       end
tables(opts={})

Microsoft SQL Server supports using the INFORMATION_SCHEMA to get information on tables.

[Source]

    # File lib/sequel/adapters/shared/mssql.rb, line 55
55:       def tables(opts={})
56:         information_schema_tables('BASE TABLE', opts)
57:       end
views(opts={})

Microsoft SQL Server supports using the INFORMATION_SCHEMA to get information on views.

[Source]

    # File lib/sequel/adapters/shared/mssql.rb, line 61
61:       def views(opts={})
62:         information_schema_tables('VIEW', opts)
63:       end

[Validate]