1、查询分析器：Select * from productsASP 网页：查询分析器：select * from products where proid= ca001b002p4 ASP 网页：查询分析器：select * from products where num200ASP 网页： “&vnum%查询分析器：select * from products where proname like %中文%ASP 网页：查询分析器：delete from products where proid= ca003b001p000007ASP 网页：查询分析器：insert into products
2、(proid,proname,price,saleprice,propic,prosource,pronote,num,favbook,cat2id)values(ca003001,ASP 案例,23,33,)insert into products values(ca003001,ASP 案例,23,33,) 默认所有的字段值都必须依次赋值insert into products(proid,proname,price,saleprice) values(ca003001,ASP 案例,23,33) 注意事项：可以空，不可以空ASP 网页：查询分析器：ASP 网页：查询分析器：ASP 网页：查询分析器：ASP 网页：查询分析器：ASP 网页：查询分析器：ASP 网页：查询分析器：ASP 网页：
