开发者

sql exception (Incorrect syntax near ')'.)

开发者 https://www.devze.com 2023-01-11 17:04 出处:网络
what is the above error please correct it string cmd = @\"SELECT * FROM [tbl_students] WHERE course_id=@courseId

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

精彩评论

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

关注公众号