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

Methods

Included Modules

Dataset::UnsupportedIntersectExcept

Constants

SELECT_CLAUSE_ORDER = %w'limit distinct columns from with join where group order having compounds'.freeze

Public Instance methods

[Source]

    # File lib/sequel/adapters/shared/mssql.rb, line 44
44:       def complex_expression_sql(op, args)
45:         case op
46:         when '||''||'
47:           super(:+, args)
48:         else
49:           super(op, args)
50:         end
51:       end

[Source]

    # File lib/sequel/adapters/shared/mssql.rb, line 53
53:       def full_text_search(cols, terms, opts = {})
54:         filter("CONTAINS (#{literal(cols)}, #{literal(terms)})")
55:       end

[Source]

    # File lib/sequel/adapters/shared/mssql.rb, line 57
57:       def multi_insert_sql(columns, values)
58:         values = values.map {|r| "SELECT #{expression_list(r)}" }.join(" UNION ALL ")
59:         ["INSERT INTO #{source_list(@opts[:from])} (#{identifier_list(columns)}) #{values}"]
60:       end

Allows you to do .nolock on a query

[Source]

    # File lib/sequel/adapters/shared/mssql.rb, line 63
63:       def nolock
64:         clone(:with => "(NOLOCK)")
65:       end

[Source]

    # File lib/sequel/adapters/shared/mssql.rb, line 67
67:       def quoted_identifier(name)
68:         "[#{name}]"
69:       end

[Validate]