SqlParameter 对同一个字段大于某值,小于某值,怎么写?
比如SELECT * FROM MyTable WHERE (recordDateTime >= @recordDateTime AND recordDateTime <= @recordDateTime),
这样写sql 语句,那么SqlParameter的 name只能是一个 @recordDateTime, 不能赋两个值啊,
不用SqlParameter就很简单, WHERE( recordDateTime >= #1-1-2012# AND recordDateTime <= #2-7-2012#,
好烦