qb icon indicating copy to clipboard operation
qb copied to clipboard

SQL Server Grammar for .whereIn / parameterization

Open MordantWastrel opened this issue 4 years ago • 1 comments

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.

MordantWastrel avatar Jun 08 '20 13:06 MordantWastrel