Posted on
2008-03-18 11:40停留的风
阅读(5145)
评论(0)
编辑收藏举报
Incorrect syntax near '@End',
不正确的SQL语句,原来是句子语法的错误,加入了一个小括号就解决问题啦。
SELECT TOP 100 FROM Table,但是如果是参数,则必须:SELECT TOP (@count)FROM Table
案例分析:在我进行分页的时候用到如下SQL语句,
SELECT F_ID,F_Card,F_AvaBegin,F_AvaEnd,F_EditTime from (selecttop@End*from (selecttop@Start*FROM T_Trade_Card_Usefullife where F_Card=@F_Card orderby F_EditTime desc)DERIVETBL orderby F_EditTime)A orderby F_EditTime desc
运行显示如下错误:
Incorrect syntax near '@End'. Incorrect syntax near '@Start'. 说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: Incorrect syntax near '@End'. Incorrect syntax near '@Start'.