DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server - Support for Microsoft SQL Server via DBD::ADO
This subclass supports MSSQL server connections via DBD::ADO.
The MSSQL specific functionality is provided by DBIx::Class::Storage::DBI::MSSQL.
_identity_method is set to @@identity,
as SCOPE_IDENTITY() doesn't work with DBD::ADO.
See "IMPLEMENTATION NOTES" in DBIx::Class::Storage::DBI::MSSQL for caveats regarding this.
There is a bug with MSSQL ADO providers where data gets truncated based on the size of the bind sizes in the first prepare call:
https://rt.cpan.org/Ticket/Display.html?id=52048
The ado_size workaround is used (see "ADO Providers" in DBD::ADO) with the approximate maximum size of the data_type of the bound column,
or 8000 (maximum VARCHAR size) if the data_type is not available.
This code is incomplete and may be buggy.
Particularly,
VARCHAR(MAX) is not supported yet.
The data_type list for other DBs is also incomplete.
Please report problems (and send patches.)
datetime_parser_type, insert, insert_bulk, last_insert_id, sql_maker, sqlt_type
DESTROY, auto_savepoint, build_datetime_parser, columns_info_for, connect_call_datetime_setup, connect_call_do_sql, connect_info, connected, create_ddl_dir, datetime_parser, dbh, dbh_do, delete, deploy, deployment_statements, disable_sth_caching, disconnect, disconnect_call_do_sql, ensure_connected, get_dbms_capability, get_use_dbms_capability, is_datatype_numeric, is_replicating, lag_behind_master, new, on_connect_call, on_connect_do, on_disconnect_call, on_disconnect_do, relname_to_table_alias, savepoints, select, select_single, set_dbms_capability, set_use_dbms_capability, sql_maker_class, sth, svp_begin, svp_release, svp_rollback, transaction_depth, txn_begin, txn_commit, txn_do, txn_rollback, unsafe, update, with_deferred_fk_checks
cursor, cursor_class, debug, debugcb, debugfh, debugobj, schema, set_schema, throw_exception, txn_scope_guard
MODIFY_CODE_ATTRIBUTES, component_base_class, mk_classaccessor, mk_classdata
inject_base
ensure_class_found, ensure_class_loaded, load_components, load_optional_class, load_optional_components, load_own_components
get_component_class, get_inherited, get_simple, get_super_paths, make_group_accessor, make_group_ro_accessor, make_group_wo_accessor, mk_group_accessors, mk_group_ro_accessors, mk_group_wo_accessors, set_component_class, set_inherited, set_simple
datetime_parser_type, insert, insert_bulk, last_insert_id, sql_maker, sqlt_type
DESTROY, auto_savepoint, build_datetime_parser, columns_info_for, connect_call_datetime_setup, connect_call_do_sql, connect_info, connected, create_ddl_dir, datetime_parser, dbh, dbh_do, delete, deploy, deployment_statements, disable_sth_caching, disconnect, disconnect_call_do_sql, ensure_connected, get_dbms_capability, get_use_dbms_capability, is_datatype_numeric, is_replicating, lag_behind_master, new, on_connect_call, on_connect_do, on_disconnect_call, on_disconnect_do, relname_to_table_alias, savepoints, select, select_single, set_dbms_capability, set_use_dbms_capability, sql_maker_class, sth, svp_begin, svp_release, svp_rollback, transaction_depth, txn_begin, txn_commit, txn_do, txn_rollback, unsafe, update, with_deferred_fk_checks
cursor, cursor_class, debug, debugcb, debugfh, debugobj, schema, set_schema, throw_exception, txn_scope_guard
MODIFY_CODE_ATTRIBUTES, component_base_class, mk_classaccessor, mk_classdata
inject_base
ensure_class_found, ensure_class_loaded, load_components, load_optional_class, load_optional_components, load_own_components
get_component_class, get_inherited, get_simple, get_super_paths, make_group_accessor, make_group_ro_accessor, make_group_wo_accessor, mk_group_accessors, mk_group_ro_accessors, mk_group_wo_accessors, set_component_class, set_inherited, set_simple
See "CONTRIBUTORS" in DBIx::Class.
You may distribute this code under the same terms as Perl itself.