开发者

sql exception (Incorrect syntax near ')'.)

what is the above error please correct it

string cmd = @"SELECT * FROM [tbl_students] WHERE course_id=@courseId 
               AND   branch_id IN(" + b开发者_运维知识库ranchId + @") 
               AND  (@firstYrPercent is null OR first_year_percent>=@firstYrPercent
               AND  (@secondYrpercent is null OR second_year_percent>=@secondYrPercent)
               AND  (@thirdYrPercent is null OR third_year_percent>=@thirdYrPercent)
               AND  (@finalYearpercent is null OR final_year_percent>=@finalYearpercent)
               AND  (@currentDegeePercentage is null OR current_degree_percent>=@currentDegeePercentage)
               AND  (@passoutYear is null OR passing_year>=@passoutYear) 
               AND  (@currentBacklog is null OR current_backlog<=@currentBacklog)
               AND   gender=@sex 
               AND  (@eGap is null OR gapin_education<=@eGap)
               AND  (@highSchoolPercentge is null OR highschool_percentage>=@highSchoolPercentge)
               AND  (@higherSchoolPercentage is null OR ssc_percentage>=@higherSchoolPercentage)
               AND  (@grauationPercentage is null OR graduation_percentage>=@grauationPercentage)
               AND  (@diplomaPercentage is null OR diploma_percentage>=@diplomaPercentage)
               AND  (@noOfAtkt is null OR number_of_ATKT<=@noOfAtkt)
               AND  (@date is null OR DOB>=@date)";


You have a missing closing parenthesis at the end of the 3rd line:

AND  (@firstYrPercent is null OR first_year_percent>=@firstYrPercent


Following line has no closing parenthesis

   AND  (@firstYrPercent is null OR first_year_percent>=@firstYrPercent
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜