來自Global的錯誤處理
在應使用條件的上下文(在 'CHARINDE' 附近)中指定了非布爾類型的表達式。 “,”附近有語法錯誤。 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 a.ClassID in (3015,3022,3055,3023,3056,3024,3057,3058,3059,3060,3061,3062,3063,3064,3065,3066,3067,3025,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3026,3078,3079,3080,3081,3082,3083,3084,3085,3086,3027,3087) 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 + ' 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 a.ClassID in (3015,3022,3055,3023,3056,3024,3057,3058,3059,3060,3061,3062,3063,3064,3065,3066,3067,3025,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3026,3078,3079,3080,3081,3082,3083,3084,3085,3086,3027,3087) 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(', 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 a.ClassID in (3015,3022,3055,3023,3056,3024,3057,3058,3059,3060,3061,3062,3063,3064,3065,3066,3067,3025,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3026,3078,3079,3080,3081,3082,3083,3084,3085,3086,3027,3087) 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 + '产精品视频在线观看免费 精品一区卡2卡3卡| 一本v亚洲v天堂一区二区| 黑色家族的秘婚魅宠7分77秒| 撸不停直播| 日本高清网站| 宝宝的水喷得到处都是小作文| 国产99精品成人免费视频| 精品毛卡卡1卡2卡3麻豆| 亚洲无码导航| 日本一本在线| 亚洲一日韩2卡3卡4卡5卡| 宋欢颜云简琛在水里| 把女朋友变成三孔插座| 视频一区国产第一页| 偷窥美女洗澡一区二区三区| 亚洲精品综合在线影院| 欧美日韩国产综合视频在线观看| 97人妻一区二区精品免费| 亚洲中文无码永久免费| 中文字幕无线观看不卡网站| 国产成人久久一区二区不卡| 国产色爽免费无码视频| 精品乱码亚洲一区二区不卡| 2018高清日本一道国产-在| 国产欧美日韩综合一区在线播放| 亚洲免费视频费观看在线| 掐着腰按在墙上| 日本一二三区免费不卡| 国产乱了伦视频大全亚琴影院| 欧美阿v高清资源不卡在线播放| 国色天香久久精品国产一区| 穿越古代做农妇继室| 日产一卡二卡福利| 日韩不卡在线观看视频不卡| 日产—卡2卡三卡四卡二卡| 嫁给首辅当继妻| 少妇一丝无挂毛片好看爽| 色妞AV永久一区二区国产AV| 亚洲国产精品一在线观看蜜桃AV| 亚洲一区二区三区四区不卡| 师父不可以(限)洛灵犀笔趣阁| 亚洲一卡2卡3卡4卡5卡国色天香| 亚洲国产精品一区二区久久第| 欧美日韩在线精品视频二区下载| 小小影视在线播放免费观看| 国内精品久久人妻无码HD浪潮| 新界名媛:总裁的第一爱妻| 日韩在线卡2卡3卡4卡5卡乱码| 亚洲精品天堂无码中文字幕影院| 色天香大豆行情网| 我等不及了就在这花园| 国产日产欧洲无码视频精品| 亚洲乱码国产乱码精品精天堂| 国产91日本一区二区三区| 韩国一卡二卡三卡四卡网站| 不知节制的索要了一整| 最新午夜国内自拍视频| 精品成人乱色一区二区| 一本一本久久a久久综合精品| 在线视频1卡二卡三卡| 亚州AV综合色区无码一区| 穿书后我成了首辅的心尖宠宋绵绵| 国产激情一区二区三区3D| 国产高清一级A片在线视频| 中文精品一卡2卡3卡4卡公司| 恶魔烙痕撒旦总裁请放手全集| 国产乱码精品一区二区三区人| 男女性爽大片在线观看| AV无码九九久久| 成人欧美一区二区三区在线视频| 密桃直播| 成人国产免费Av一区二区三区| 性爱工作室| 偷窥美女洗澡一区二区三区| 重生军婚首长大人宠宠宠| 你说过不会碰我的别让我恨你| 高门恶毒主母重生了| 欧美一卡2卡三卡4卡公司动漫| 亚洲一卡二卡三卡| 一区二区三区擁有海量影視資源| 国产成人无码WWW免费视频在线| 国产精品成人图片一区| 总裁只婚不爱:天价弃妻| 亚洲高清无码视频在线| 久久综合亚洲色HEZYO国产| 国产在线视频欧美一区二区三区| 赵倩宋欣欣川藏线记忆| 国产一卡2卡3卡4卡新区乱码| 无码人妻久久一区二区| 学长~能把遥控器关了嘛作文文轩| 欧洲一卡2卡三卡4卡网站国色天香| 欧美日韩在线亚洲一| 成年午夜视频在线观看131| 欧美 日韩| 亚洲欧洲一区二区不卡| 无码一卡| 中日无码视频一区二区三区| 一卡二卡三卡,欧美,日韩,电影| 日本一卡| 日韩精品一区二区三区四区| 丰满人妻大屁股一区二区| 日韩欧美一卡2卡3卡4卡5卡免费| 丰满少妇| 亚洲AV成人无码国产电影| 糖豆直播| 日产一卡三卡四卡免费| 大肚子挺着还要上下抽插不停| 国产成人精品一区二区三区免费|