Question

‘=’附近有语法错误

“‘=’附近有语法错误。”
System.Data.SqlClient.SqlException:"'='附近有语法错误
public bool Update2(sora_users_id sui)
{
string sql =
"UPDATE sora_users_id" +
"SET" +
"s_shenpiliucheng = @s_shenpiliucheng," +
"WHERE s_uid = @s_uid";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@s_shenpiliuchen",sui.s_shenpiliucheng)
};
return SqlHelper.ExecuteNonQuery(CommandType.Text, sql, para) > 0;
}
上面是我写的修改类
为何有错 很好奇

Answer 1

string sql =
"UPDATE sora_users_id " + //拼SQL要注意空格
" SET " +
" s_shenpiliucheng = @s_shenpiliucheng," +
" WHERE s_uid = @s_uid";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@s_shenpiliuchen",sui.s_shenpiliucheng)
new SqlParameter("@s_uid",sui.s_uid) };