ADO.NET学习笔记--多值匹配

1.in(value1,value2)

Delete Employ where id in(21,22)

2.and,between..and..

范围值:

SELECT * FROM T_Employee WHERE FAGE>=23 AND FAGE <=27

SELECT * FROM T_Employee WHERE FAGE BETWEEN 23 AND 27

posted @ 2013-02-28 13:40  davidlovelife  阅读(172)  评论(0编辑  收藏  举报