Class | Sequel::ADO::MSSQL::Dataset
In: | lib/sequel/adapters/ado/mssql.rb
Parent: | ADO::Dataset

### Methods

insert provides_accurate_rows_matched?

### Included Modules

Sequel::MSSQL::DatasetMethods

### Public Instance methods

insert(*values)

Use a nasty hack of multiple SQL statements in the same call and having the last one return the most recently inserted id. This is necessary as ADO‘s default :provider uses a separate native connection for each query.

[Source]

        # File lib/sequel/adapters/ado/mssql.rb, line 49
    49:         def insert(*values)
    50:           return super if @opts[:sql]
    51:           with_sql("SET NOCOUNT ON; #{insert_sql(*values)}; SELECT CAST(SCOPE_IDENTITY() AS INTEGER)").single_value
    52:         end

provides_accurate_rows_matched?()

If you use a better :provider option for the database, you can get an accurate number of rows matched.

[Source]

        # File lib/sequel/adapters/ado/mssql.rb, line 56
    56:         def provides_accurate_rows_matched?
    57:           !!db.opts[:provider]
    58:         end

[Validate]