1. 去掉“只读”属性。
2. 在SQL Server2000中，附加数据库UGMS。
3. 编译不受源文件位置和数据库位置的影响。即，HMS的整个工程复制到任何地方都可编译。-1. Remove the " Read Only" attribute. 2. In SQL Server2000, the additional database UGMS. 3. Compiled from the source file location and database location of impact. Namely, HMS copy of the entire project can be compiled anywhere.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001289s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.074031s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001041s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001295s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001005s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003099s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000851s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004097s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014454s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001456s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 168081 [ RunTime:0.018684s ]
