qb
qb copied to clipboard
SQL Server Grammar for .whereIn / parameterization
Probably not a good default, but a useful workaround for the 2,100 parameter limit in SQL Server 2016+ from Zac Spitzer:
https://dev.lucee.org/t/is-it-possible-to-use-cf-sql-array-with-an-in-clause/4710/3
It'd be nice to be able to ask QB to do this on a given array instead of param'ing it.