SQL查询错误
问题描述:
给错误下面Ÿ提到的,所以请纠正我对这个
消息137,级别15,状态2,行1 必须声明标量变量“@courseId”。
@"SELECT * FROM [tbl_students] WHERE [email protected] AND branch_id IN("[email protected]")
AND (@passoutYear is null OR passing_year>[email protected])
AND (@currentBacklog is null OR current_backlog<[email protected])
AND [email protected] AND (@eGap is null OR gapin_education<[email protected])
AND (@firstYrPercent is null OR first_year_percent>[email protected]
AND (@secondYrpercent is null OR second_year_percent>[email protected])
AND (@thirdYrPercent is null OR third_year_percent>[email protected])
AND (@finalYrpercent is null OR final_year_percent>[email protected])
AND (@currentDegreePercentage is null OR current_degree_percent>[email protected])
AND (@highSchoolPercentage is null OR highschool_percentage>[email protected])
AND (@higherSchoolPercentage is null OR ssc_percentage>[email protected])
AND (@graduationPercent is null OR graduation_percentage>[email protected])
AND (@diplomaPercentage is null OR diploma_percentage>[email protected])
AND (@noOfAtkt is null OR number_of_ATKT<[email protected])
AND (@date is null OR DOB>[email protected])"
答
这只是意味着你忘了你的命令创建@courseId
的SqlParameter
值。
答
您可以:
- 未声明的SQL查询
- 内您的变量
@courseId
不声明参数,存储过程
请编辑您的[原来的问题(HTTP:/ /*.com/questions/3499381/please-correct-me-with-the-sql-query)而不是创建一个新的。 – BoltClock 2010-08-17 05:39:15
@BoltClock:原始问题(3499381)似乎是由于在查询字符串开始之前省略了@符号而导致的错误 - 请参阅Helgi Hrafn Gunnarsson的回答,该回答被接受为正确。这个问题涉及SQL本身的错误;因此,我认为把它作为原始问题的重复来解决是错误的。我不知道该怎么做,但我建议重新打开这个问题。 – 2010-08-19 13:13:45
请你回答一些已经留给这个问题的答案。 – 2010-08-19 13:14:53