同时执行多条SQL语句
public int U_AppUser_Price(int> {StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_article set click=click-1 where;update a set a.amount=a.amount-{0} from dt_appusers a join dt_article b on a.id=b.user_id where b.id={1}",tg_price,id);//注意加分号和占位符
return DbHelperSQL.ExecuteSql(strSql.ToString());
}
页:
[1]