MySQL5.1ÄÚ±íתµ½MS SQL£¬±í½á¹¹Ó¦ÈçºÎÉèÖã¿
# MySQL-Front 5.1 (Build 4.2)
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
# Host: localhost Database: scanmaster
# ------------------------------------------------------
# Server version 5.1.46-community
#
# Source for table tabapp
#
DROP TABLE IF EXISTS `tabapp`;
CREATE TABLE `tabapp` (
`appid` int(4) NOT NULL AUTO_INCREMENT,
`appname` varchar(32) NOT NULL DEFAULT '',
`apppath` varchar(255) CHARACTER SET gbk COLLATE gbk_bin NOT NULL DEFAULT '',
`outputpath` varchar(255) CHARACTER SET gbk COLLATE gbk_bin NOT NULL DEFAULT '',
`indexed` int(4) NOT NULL DEFAULT '0',
`key1` varchar(64) DEFAULT NULL,
`key2` varchar(64) DEFAULT NULL,
PRIMARY KEY (`appid`),
UNIQUE KEY `appname` (`appname`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=gbk;
#
# Dumping data for table tabapp
#
LOCK TABLES `tabapp` WRITE;
/*!40000 ALTER TABLE `tabapp` DISABLE KEYS */;
INSERT INTO `tabapp` VALUES (4,'FDCdoc1','\\\\aqlcserver\\in$\\FDCdoc1','\\\\aqlcserver\\out$\\FDCdoc1',1,'Åú´ÎºÅ','ºÐÄÚÐòºÅ');
/*!40000 ALTER TABLE `tabapp` ENABLE KEYS */;
UNLOCK TABLES;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
ÒÔÉÏÊÇMySQLµ¼³ö±íµÄSQL,ÈôÔÚMS SQLÖн¨Á¢ÏàͬµÄ±í£¬ºìÉ«×ÖÌ岿·ÖÔÚMS SQLÖÐÈçºÎÉèÖã¿
Ïà¹ØÎĵµ£º
http://immike.net/blog/2007/04/09/how-not-to-optimize-a-mysql-query/
ÕâÆªÎÄÕ½¨Ò飺
£¨1£©²»ÒªÊ¹ÓÃһЩmysqlµÄtip£¬È磺SQL_SMALL_RESULT, HIGH/LOW_PRIORITY, and INSERT DELAYED£¬STRAIGHT_JOIN£¬³ý·ÇûÓÐÆäËû·½·¨£¬ÒòΪÕâÑùʧȥÁËSQLµÄ¿ÉÒÆÖ²ÐÔ
£¨2£©Êʵ±¶Ô±í½øÐÐË÷Òý
£¨3£©±ÜÃâ¶Ô²»±ØÒªÊý¾ÝµÄ²éѯ
£¨4£©´¦Àí× ......
ACCESSÊý¾Ý¿â
1:CodeSmithÑ¡ÖÐÁ´½ÓÀàÐÍÊÇ£ºADOXSchema
2:ÎÞÃÜÂëµÄAccessÁ´½ÓΪ£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\hh\db.mdb;
3:ÓÐÃÜÂëµÄAccessÁ´½Ó£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\hh\db.mdb;
Jet OLEDB:Database Password=1111
SqlÊý¾Ý¿â
server=192.1.1.14;User ID=test; ......
SQL Server Êý¾Ý¿â¹ÜÀí³£ÓõÄSQLºÍT-SQLÓï¾ä
1. ²é¿´Êý¾Ý¿âµÄ°æ±¾
select @@version
2. ²é¿´Êý¾Ý¿âËùÔÚ»úÆ÷²Ù×÷ϵͳ²ÎÊý
exec master..xp_msver
3. ²é¿´Êý¾Ý¿âÆô¶¯µÄ²ÎÊý
sp_configure
4. ²é¿´Êý¾Ý¿âÆô¶¯Ê±¼ä
select convert(varchar(30),login_time,120) from master..sysprocesses where spid=1
²é¿´Êý ......
·½°¸Ò»£ºSQL×Ô´øµÄÊý¾Ý¿â±¸·Ý¼Æ»®
Ò»£º»ù±¾Ë¼Â·
1£ºÒªÊµÏÖÒìµØ±¸·Ý£¬±ØÐëʹÓÃÓòÓû§ÕʺÅÀ´Æô¶¯SQL Server·þÎñÒÔ¼°SQL Server Agent·þÎñ£¬ÒòΪ±¾µØÏµÍ³ÕÊ»§ÎÞ·¨·ÃÎÊÍøÂç¡£
2£ºÔÚÒìµØ»úÆ÷Öн¨Á¢Ò»¸öÓëSQL Server·þÎñÆ÷ÖÐÆô¶¯SQL Server·þÎñµÄÓòÓû§ÕʺÅͬÃûÕʺÅ,ÇÒÃÜÂë±£³ÖÏàͬ¡£ÔÚÒìµØ»úÆ÷Öн¨Á¢Ò»¸ö¹²ÏíÎļþ¼Ð£¬²¢ÉèÖÃºÏ ......