flex net sql2005 增删改查 仿goog百度搜索

--select * from jtxx -- --insert jtxx(jtbh,jtmc,bzId) values('6#','六号机组','6') -- --delete jtxx where id=6 -------------------------- ---select * from chanpin select top 100 * from products order by id desc select * from products insert products(cpdm,cpmc,cpzz,cpkz,cpzs) values('60pk','平开框','41','52','63') select * from products WHERE cpdm LIKE '%pk%' select * from bumen insert bumen(idd,bmbh,bmmc) values('4','12','人力资源部') select * from Tj_user insert Tj_user(Users_Name,pwd)values('tjzc','tjzc') select * from Tj_User where users_name='tjzc' and pwd='tjzc' select * from Tj_User insert Tj_User(Users_Name,pwd) values('tjzc','tjzc') -------20110516------ select top 100 * from jtxx order by id desc ALTER TABLE jtxx ADD bzId int ---修改表结构，增加新列 update jtxx set bzId=150 where id='150' select * from jtxx insert jtxx(jtbh,jtmc,bzId) values('4#','四号机组','4') -------------------- select * from products sp_help products insert products(cpdm,cpmc,cpzz,cpkz,cpzs) values('60pkk','60平开框','33','22','32') select * from bumen