In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Exception: Too many parameters were provided in this RPC request. The maximum is 2100.
[Microsoft] [SQL Native Client] [SQL Server] The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100.
Error report of SQL statement
If it is a SELECT query OR conditional statement such as: SELECT * FROM tablename WHERE x1 OR x2 OR x3 OR x4 OR. If the number of OR x2101 or conditions exceeds 2100, an error will be reported, which can be changed to UNION ALL.
If it is a SELECT query IN conditional statement such as: SELECT * FROM tablename WHERE columnname IN (1, 2, 3, 4, 5,. , 2101), if the number of IN parameters exceeds 2100, the above error will be reported. You can create a temporary table, write this data to the temporary table, and then associate it.
-- Create new table Create Table temp (myvalues uniqueidentifier)-- Join new table with your table SELECT T1 * FROM tablename T1 JOIN temp T2 ON t1.myvalues = t2.myvalues
Error reporting of stored procedures and functions
For stored procedures and functions, the maximum number of parameters is 2100
See the following restrictions:
Https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.