.net拼接sql语句in('xxx','xxx')
来源:岁月联盟
时间:2011-09-07
要求传递过来的字符串格式为:xxxx,xxx,xxxxx,xxxx,(两边可以有逗号).
string.Format("delete table1 where id in ('{0}')", ids.Trim(',').Replace(",", "','"));
作者“robot的学习日志”