来自Global的错误处理<br />“+”附近有语法错误。
字符串 '' 后的引号不完整。
“”附近有语法错误。
 
SELECT TOP 0 IDENTITY(int,1,1) AS RowIndex,a.ProductID * 1 as ProductID,a.ProductName,a.ClassID,a.RlCode,a.MacCode,a.ProLabel,(SELECT ClassName + ',' FROM dbo.CNVP_Class WHERE ClassArea = 3 AND CHARINDEX(CAST(ClassID AS VARCHAR(200)),',' + a.FitCar + ',')>0  FOR XML PATH('') ) AS FitName,(SELECT COUNT(*) FROM dbo.CNVP_Favorite WHERE ProductID = a.ProductID) AS FavCnt,ProCnt=0,b.ImgAddress, case when ImgAddress is null then 0 else 1 end as IsHasImg INTO  #tmpPage FROM CNVP_Product  a LEFT JOIN (SELECT * FROM CNVP_ProductImg WHERE IsMain = 1) b ON a.ProductID = b.ProductID WHERE 1 = 1 and isnull(a.Status,0) = 0   and( CHARINDEX(',2753,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3237,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2800,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2801,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2802,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2803,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2804,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2805,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2806,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2807,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2808,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2809,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2810,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2811,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2812,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2954,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2971,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2981,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2982,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2759,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2813,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2814,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2815,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2816,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2817,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2818,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2998,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3000,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3001,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3002,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2763,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2829,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2830,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2831,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2832,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2986,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2760,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2819,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2820,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2821,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2761,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2822,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2823,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2824,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2825,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2765,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2835,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2836,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2837,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2838,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2839,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2764,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3222,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2833,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2834,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2767,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2843,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2844,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2768,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2845,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2846,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2955,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2956,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2972,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2973,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2974,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2975,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2762,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2826,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2827,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2828
INSERT INTO #tmpPage SELECT TOP 20 a.ProductID * 1 as ProductID,a.ProductName,a.ClassID,a.RlCode,a.MacCode,a.ProLabel,(SELECT ClassName + ',' FROM dbo.CNVP_Class WHERE ClassArea = 3 AND CHARINDEX(CAST(ClassID AS VARCHAR(200)),',' + a.FitCar + ',')>0  FOR XML PATH('') ) AS FitName,(SELECT COUNT(*) FROM dbo.CNVP_Favorite WHERE ProductID = a.ProductID) AS FavCnt,ProCnt=0,b.ImgAddress, case when ImgAddress is null then 0 else 1 end as IsHasImg FROM CNVP_Product  a LEFT JOIN (SELECT * FROM CNVP_ProductImg WHERE IsMain = 1) b ON a.ProductID = b.ProductID WHERE 1 = 1 and isnull(a.Status,0) = 0   and( CHARINDEX(',2753,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3237,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2800,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2801,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2802,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2803,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2804,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2805,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2806,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2807,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2808,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2809,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2810,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2811,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2812,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2954,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2971,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2981,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2982,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2759,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2813,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2814,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2815,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2816,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2817,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2818,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2998,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3000,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3001,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3002,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2763,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2829,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2830,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2831,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2832,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2986,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2760,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2819,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2820,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2821,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2761,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2822,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2823,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2824,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2825,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2765,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2835,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2836,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2837,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2838,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2839,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2764,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3222,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2833,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2834,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2767,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2843,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2844,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2768,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2845,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2846,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2955,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2956,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2972,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2973,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2974,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2975,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2762,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2826,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2827,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2828,',',' + a.FitCar + ','
SELECT TOP 0 IDENTITY(int,1,1) AS RowIndex,a.ProductID * 1 as ProductID,a.ProductName,a.ClassID,a.RlCode,a.MacCode,a.ProLabel,(SELECT ClassName + ',' FROM dbo.CNVP_Class WHERE ClassArea = 3 AND CHARINDEX(CAST(ClassID AS VARCHAR(200)),',' + a.FitCar + ',')>0  FOR XML PATH('') ) AS FitName,(SELECT COUNT(*) FROM dbo.CNVP_Favorite WHERE ProductID = a.ProductID) AS FavCnt,ProCnt=0,b.ImgAddress, case when ImgAddress is null then 0 else 1 end as IsHasImg INTO  #tmpPage FROM CNVP_Product  a LEFT JOIN (SELECT * FROM CNVP_ProductImg WHERE IsMain = 1) b ON a.ProductID = b.ProductID WHERE 1 = 1 and isnull(a.Status,0) = 0   and( CHARINDEX(',2753,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3237,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2800,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2801,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2802,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2803,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2804,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2805,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2806,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2807,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2808,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2809,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2810,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2811,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2812,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2954,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2971,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2981,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2982,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2759,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2813,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2814,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2815,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2816,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2817,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2818,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2998,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3000,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3001,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3002,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2763,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2829,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2830,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2831,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2832,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2986,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2760,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2819,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2820,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2821,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2761,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2822,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2823,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2824,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2825,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2765,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2835,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2836,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2837,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2838,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2839,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2764,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3222,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2833,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2834,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2767,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2843,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2844,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2768,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2845,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2846,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2955,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2956,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2972,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2973,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2974,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2975,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2762,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2826,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2827,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2828