sql server压缩查询错误。解析查询时出错。 [令牌行号= 1，令牌行偏移= 12，令牌错误= 1]。 [英] sql server compact query error.There was an error parsing the query. [ Token line number = 1,Token line offset = 12,Token in error = 1 ] .

问题描述

我的代码在C＃Asp.net中，

Hi,
My code is in C# Asp.net is,

con.Open();

                string qry1 = "select top 1 a.coursename,a.name,a.feespaid,a.admissionid,b.invoicenumber from tb_studentfees a inner join tb_invoice b on a.admissionid=b.admissionid where a.admissionid="+ lbladmissionnumber.Text +" order by b.invoicenumber desc";
                SqlCeDataAdapter da1 = new SqlCeDataAdapter(qry1, con);
                DataTable dt = new DataTable();
                da1.Fill(dt);
                if (dt.Rows.Count > 0)
                {

我在MSSQL中成功运行此查询，但显示错误



解析查询时出错。[令牌行号= 1，令牌行偏移= 12，错误令牌= 1]

<在SQL Server compact中，


。



请帮助。

I run this query successfully in MSSQL,but showing error

"There was an error parsing the query. [ Token line number = 1,Token line offset = 12,Token in error = 1 ] "


in SQL Server compact.

Please help.

推荐答案

尝试

select top (1) ...

请参阅 MS参考 [ ^ ]

这篇关于sql server压缩查询错误。解析查询时出错。 [令牌行号= 1，令牌行偏移= 12，令牌错误= 1]。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！