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

Question

in括号内集合数超出108个报错，少于108个就能正常执行

USE [test_ZSdata]
GO

DECLARE @return_value int

EXEC @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_value

GO

消息：消息 102，级别 15，状态 1，第 14 行
“111”附近有语法错误。

(1 行受影响)

Answer 1

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