NAME

DBIx::Class::Storage::DBI::IdentityInsert - Storage Component for Sybase ASE and MSSQL for Identity Inserts / Updates

DESCRIPTION

This is a storage component for Sybase ASE (DBIx::Class::Storage::DBI::Sybase::ASE) and Microsoft SQL Server (DBIx::Class::Storage::DBI::MSSQL) to support identity inserts, that is inserts of explicit values into IDENTITY columns.

This is done by wrapping INSERT operations in a pair of table identity toggles like:

  SET IDENTITY_INSERT $table ON
  $sql
  SET IDENTITY_INSERT $table OFF

INHERITED METHODS

DBIx::Class::Storage::DBI

auto_savepoint, bind_attribute_by_data_type, build_datetime_parser, columns_info_for, connect_call_datetime_setup, connect_call_do_sql, connect_info, connected, create_ddl_dir, datetime_parser, datetime_parser_type, dbh, dbh_do, delete, deploy, deployment_statements, disable_sth_caching, disconnect, disconnect_call_do_sql, ensure_connected, get_dbms_capability, get_use_dbms_capability, insert, insert_bulk, is_datatype_numeric, is_replicating, lag_behind_master, last_insert_id, new, on_connect_call, on_connect_do, on_disconnect_call, on_disconnect_do, relname_to_table_alias, select, select_single, set_dbms_capability, set_use_dbms_capability, source_bind_attributes, sql_limit_dialect, sql_maker, sql_maker_class, sql_name_sep, sql_quote_char, sqlt_type, sth, svp_begin, svp_release, svp_rollback, txn_begin, txn_commit, txn_do, txn_rollback, unsafe, update, with_deferred_fk_checks

DBIx::Class::Storage

cursor, cursor_class, debug, debugcb, debugfh, debugobj, savepoints, schema, set_schema, throw_exception, transaction_depth, txn_scope_guard

AUTHOR

See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.

LICENSE

You may distribute this code under the same terms as Perl itself.