/ 
DBIO-0.900000
/ DBIO::Storage::DBI::IdentityInsert

NAME

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

VERSION

version 0.900000

DESCRIPTION

This is a storage component for Sybase ASE (DBIO::Sybase::Storage::ASE) and Microsoft SQL Server (DBIO::MSSQL::Storage) 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

METHODS

_prep_for_execute

When explicit identity values are supplied, wrap generated SQL with SET IDENTITY_INSERT ... ON/OFF statements for the target table.

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.