62,025
社区成员
发帖
与我相关
我的任务
分享
StringBuilder strSql=new StringBuilder();
strSql.Append("delete from test ");
strSql.Append(" where ID in (@IDs) "); //参数
SqlParameter[] parameters = {
new SqlParameter("@IDs", DbType.String)};
parameters[0].Value = "2,3,4,5";
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
command.CommandText = "delete test where CharIndex( ',' + Cast(fieldname As Varchar) + ',', ',' + @param + ',') > 0";
SqlParameter param = new SqlParameter();
param.ParameterName = "@param";
param.Value = "1,2,3,4,5";
command.Parameters.Add(param);
strSql.Append("delete test where ID in (");
var s="";
foreach(var id in ids){
strSql.Append(s).Append(id);
s=",";
}
strSql.Append(")");