存储过程 in()参数集合过多报错

Question

in括号内集合数超出108个报错，少于108个就能正常执行USE [test_ZSdata]GODECLARE @return_value intEXEC @return_value = [dbo].[CRM_DeliveryOrdernVW_Search]@Condition = N'DeliveryOrdernId in (111,111,111,111,111,111,111,111,111,111, 111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111, 111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111, 111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111, 111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111, 111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111,111)'SELECT 'Return Value' = @return_valueGO消息：消息 102，级别 15，状态 1，第 14 行“111”附近有语法错误。(1 行受影响)

Answer 1

应该是 @Condition 变量定义的长度不够