Почему предел параметров SQL Server достигается для строковых идентификаторов, но не для идентификаторов с автоматически ⇐ Php

[Anonymous]

I'm building a software project (PHP & Laravel) that uses an ORM to generate SQL. I'm hitting an SQL Server (2019) parameter limit of 2100 (using where in) but only when using string IDs and not when using integer IDs. Why would this be the case? I would expect to hit the 2100 limit regardless of the parameter type.

Example query:

select * from [users] where [users].[id] in ( 'adhc05', 'yizj19', 'rues03', 'usaw47', 'ddta80', 'tdls80', 'vfjf76', 'sohy36', 'ucxm31', 'zwzo73', etc... ) order by [users].[id] asc SQLSTATE[IMSSP]: Tried to bind parameter number 2101. SQL Server supports a maximum of 2100 parameters.

The following query does not hit the parameter limit, even though it's selecting more than 2100 users:
select * from [users] where [users].[id] in ( 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, etc... ) order by [users].[id] asc

Источник: https://stackoverflow.com/questions/781 ... o-incremen