This articles shows how to retrieve a list of PCs on the local network which are running MS SQL Server, and gets information about the instances, such as server name, instance name, version, and databases.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.005958s ]
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.214767s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.004088s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001208s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002125s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003416s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001007s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003859s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015562s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001128s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 365407 [ RunTime:0.010796s ]