in括號內集合數(shù)超出108個報錯,少于108個就能正常執(zhí)行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,狀態(tài) 1,第 14 行“111”附近有語法錯誤。(1 行受影響)
存儲過程 in()參數(shù)集合過多報錯
婷婷同學_
2018-08-14 10:09:35