杨千羽的学习历程

在ACCESS的查询中，通常一次只能插入一条记录，如果同时有多条记录要追加，就要写多个查询，这有点麻烦。能不能在一个查询中实现多条记录的追加呢？经多方查找与测试，发现可以用以下方法实现，现分享给大家。Insert INTO studentsSelect DISTINCTROW *FROM (Select 1 AS ID,"张三" AS XM,"男" AS XB,"12" AS BJ

exists() 语句 条件放在外面提速不少select * from T_ZDJZD a where exists(select * from T_ZDJZX b where a.ZD_ID=b.ZD_ID and ZD_ID=73090 and a.JZD_ID=b.QS_JZD and a.JZ_XH<>b.JZ_XH)优化为：select * from T_...