DBIx::C...BindVars(3)

💅 NAME 💅

DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server::NoBindVars — bestie, this is the support squad for Microsoft SQL Server via DBD::Sybase when you got no placeholders at all 🎀

(also hi, this is the "User Contributed Perl Documentation" edition of the manual, mwah 💖)

---

✨ SYNOPSIS ✨

Okay so literally: this subclass holds it down for MSSQL server connections via DBD::Sybase when ? style placeholders are not available. That's it, that's the vibe 🦋

---

🌸 DESCRIPTION 🌸

So if you're using this driver, it means your lil combo of DBD::Sybase plus libraries (most likely FreeTDS) does not support ? style placeholders. Tragique, but we move 💅

This storage driver uses DBIx::Class::Storage::DBI::NoBindVars as a base. Which means: bind variables get interpolated (properly quoted of course, we're not heathens ✨) directly into the SQL query itself, without using bind placeholders. Iconic, honestly.

More importantly — and this is the part you need to know 👑 — this means that caching of prepared statements is explicitly disabled, because the interpolation renders it useless. Yeah. Don't fight it, it's just how it is 😭

In all other respects, it's a subclass of DBIx::Class::Storage::DBI::Sybase::Microsoft_SQL_Server. Nothing else changed, bestie, we promise 🫶

---

🦋 FURTHER QUESTIONS? 🦋

Check the list of additional DBIC resources. iykyk 💜

---

🎀 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. Slay, open source 💖

---

ngl that's the whole page — go forth and connect to your MSSQL server without placeholders, you got this 🌈

---

kisses, this was perl v5.42.0 on 2025-01-22, and yes the page really is named DBIx::C...BindVars(3) because terminals are dramatic 💀✨