DBIx::C...tyInsert(3)

💅 DBIx::C...tyInsert(3) 💅

okay so this page is from the User Contributed Perl Documentation crew, and it's giving very specific database-storage energy ✨

---

✨ NAME ✨

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

---

🦋 DESCRIPTION 🦋

So this is a storage component for Sybase ASE (DBIx::Class::Storage::DBI::Sybase::ASE) and Microsoft SQL Server (DBIx::Class::Storage::DBI::MSSQL) that supports identity inserts — aka inserts of explicit values into IDENTITY columns. no cap, that's the whole point 💖

It does this by wrapping INSERT operations in a pair of table identity toggles, like this iconic little sandwich:

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

literally toggles on, runs the SQL, toggles off. slay 💅

---

💀 FURTHER QUESTIONS? 💀

Check the list of additional DBIC resources, bestie. that's where the extra lore lives 🧚

---

🎀 COPYRIGHT AND LICENSE 🎀

This module is free software copyright by the DBIx::Class (DBIC) authors. You can redistribute it and/or modify it under the same terms as the DBIx::Class library. periodt 💜

---

that's the page, bestie 🫶 source/version sign-off: perl v5.42.0, dated 2025-01-22, and the page itself is DBIx::C...tyInsert(3) ✨🌸