dsCommand.UpdateCommand.CommandText = "UPDATE authors"+ "SET"+ "city = @City"+ "Where au_id = @Id";
我帮我SQL语句写成这种格式,始终出现这种错误:
System.Data.SqlClient.SqlException: 第 1 行: '=' 附近有语法错误。
而我将SQL写成这样就没错误
dsCommand.UpdateCommand.CommandText = "UPDATE authors SET city = @City Where au_id = @Id"
请教错在那里?????
谢谢
我帮我SQL语句写成这种格式,始终出现这种错误:
System.Data.SqlClient.SqlException: 第 1 行: '=' 附近有语法错误。
而我将SQL写成这样就没错误
dsCommand.UpdateCommand.CommandText = "UPDATE authors SET city = @City Where au_id = @Id"
请教错在那里?????
谢谢
dsCommand.UpdateCommand.CommandText = "UPDATE authors "+
"SET "+
"city = @City"+
" Where au_id = @Id";