看看这段代码哪里错了?

[Big鹏]

public void UpdateScanTime(string beiyongzi, string beiyongzifu)
        {
            StringBuilder strSql = new StringBuilder();
            //提示TOP附近有语法错误，请问哪里错了？
            strSql.Append("update top 1 Event set BeiYongZi=@beiyongzi,BeiYongZiFu=@BeiYongZiFu ");
            SqlParameter[] parameters =
                {
                    new SqlParameter ("@beiyongzi",SqlDbType .VarChar ,255),
                    new SqlParameter ("@beiyongzifu",SqlDbType .VarChar ,255)

                };
            parameters[0].Value = beiyongzi;
            parameters[1].Value = beiyongzifu;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

        }

[fengqiyueluo]

不足道也，恩，我们写的时候top 1 后加'*',你try

[htl258_Tony]

update top (1) Event set BeiYongZi=@beiyongzi,BeiYongZiFu=@BeiYongZiFu --加个括号试下

[conan304]

public void UpdateScanTime(string beiyongzi, string beiyongzifu)
        {
            StringBuilder strSql = new StringBuilder();
            //提示TOP附近有语法错误，请问哪里错了？
            strSql.Append("update top (1) Event set BeiYongZi=@beiyongzi,BeiYongZiFu=@BeiYongZiFu ");
            SqlParameter[] parameters =
                {
                    new SqlParameter ("@beiyongzi",SqlDbType .VarChar ,255),
                    new SqlParameter ("@beiyongzifu",SqlDbType .VarChar ,255)

                };
            parameters[0].Value = beiyongzi;
            parameters[1].Value = beiyongzifu;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

        }

[百年树人]

try--

update Event set BeiYongZi=@beiyongzi,BeiYongZiFu=@BeiYongZiFu where id in(select top 1 id from Event order by id)

[ks_reny]

沒有見過這樣的SQL語句.

[lg3605119]

2005是支持TOP 的