1¡¢.back ?DB? FILE ±¸·ÝDB(ĬÈÏΪmain)µ½Îļþ
2¡¢.bail ON|OFF Óöµ½Ò»¸ö´íÎó¿ÛÍ£Ö¹£¬¸ÃֵĬÈÏΪOFF
3¡¢.databases Áоٸ½¼Óµ½Êý¾Ý¿âµÄÊý¾Ý¿âÃûºÍÎļþÃû
4¡¢.dump ?TABLE? ... ÓÃSQLÎı¾¸ñʽÁоÙÊý¾Ý¿â£¬Èç¹ûÖ¸¶¨TABLE£¬½ö½öÁÐ¾ÙÆ¥ÅäµÄ±í£¬LIKEÀàÐÍTABLE
5¡¢.echo ON|OFF ÉèÖÃechoµÄ״̬¿ÉÒÔΪON»òÕßOFF
6¡¢.exit Í˳ö³ÌÐò
7¡¢.explain ?ON|OFF? ÉèÖÃEXPLAINµÄÊä³öģʽΪON»òÕßOFF£¬Èç¹ûûÓвÎÊý£¬EXPLAINĬÈÏÉèÖÃΪON
8¡¢.genfkey ?OPTIONS?
Ñ¡ÏîÉèÖÃÈçÏ£º
--NO-DROP:±íʾ²»É¾³ý¾ÉµÄfkey´¥·¢Æ÷
--IGNORE-ERRORS:±íʾºöÂÔº¬ÓÐfkey´íÎóµÄ±í
--EXEC:±íʾÁ¢¼´Ö´ÐÐÉú³ÉµÄSQLÓï¾ä
ÔÚÐÅÏ¢Ô´Öв鿴Îļþtool/genfkey.READMEÀ´½øÒ»²½Á˽â¸üÏêϸµÄÄÚÈÝ
9¡¢.help ÏÔʾSQLiteµÄ²Ù×÷Ö¸ÄÏ
10¡¢.import FILE TABLE ±íʾÏò±íÖе¼ÈëÊý¾Ý
11¡¢.indices ?TABLE? ÏÔʾËùÓеÄË÷ÒýÃû£¬Èç¹ûÖ¸¶¨TABLE£¬ÄÇô½ö½öÏÔʾָ¶¨±íµÄË÷Òý£¬ÀýÈ磬±íµÈÅäÌ×ģʽ
12¡¢.load FILE ?ENTRY? ¼ÓÔØÒ»¸öÍⲿµÄ¿â
13¡¢.mode MODE ?TABLE? ÉèÖÃÊä³öģʽ£¬¿É ......
SqlServer,Oracle ³£Óú¯Êý±È½Ï
Êýѧº¯Êý£º
1.¾ø¶ÔÖµ
¡¡¡¡ Sql Server: SELECT abs(-1) value
¡¡¡¡ Oracle: SELECT abs(-1) value from dual
2.È¡Õû(´ó)
¡¡¡¡ Sql Server: SELECT ceiling(-1.001) value
¡¡¡¡ Oracle: SELECT ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
¡¡¡¡ Sql Server: SELECT floor(-1.001) value
¡¡¡¡ Oracle: SELECT floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
¡¡¡¡ Sql Server: SELECT cast(-1.002 as int) value
¡¡¡¡ Oracle: SELECT trunc(-1.002) value from dual
5.ËÄÉáÎåÈë
¡¡¡¡ Sql Server: SELECT round(1.23456,4) value 1.23460
¡¡¡¡ Oracle: SELECT round(1.23456,4) value from dual 1.2346
6.eΪµ×µÄÃÝ
¡¡¡¡ Sql Server: SELECT Exp(1) value 2.7182818284590451
¡¡¡¡ Oracle: SELECT Exp(1) value from dual 2.71828182
7.È¡eΪµ×µÄ¶ÔÊý
¡¡¡¡ Sql Server: SELECT log(2.7182818284590451) value 1
¡¡¡¡ Oracle: SELECT ln(2.7182818284590451) value from dual; 1
8.È¡10Ϊµ×¶ÔÊý
¡¡¡¡ Sql Server: SELECT log10(10) value 1
¡¡¡¡ Oracle: SELECT log(10,10) value from dual; 1
......
SqlServer,Oracle ³£Óú¯Êý±È½Ï
Êýѧº¯Êý£º
1.¾ø¶ÔÖµ
¡¡¡¡ Sql Server: SELECT abs(-1) value
¡¡¡¡ Oracle: SELECT abs(-1) value from dual
2.È¡Õû(´ó)
¡¡¡¡ Sql Server: SELECT ceiling(-1.001) value
¡¡¡¡ Oracle: SELECT ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
¡¡¡¡ Sql Server: SELECT floor(-1.001) value
¡¡¡¡ Oracle: SELECT floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
¡¡¡¡ Sql Server: SELECT cast(-1.002 as int) value
¡¡¡¡ Oracle: SELECT trunc(-1.002) value from dual
5.ËÄÉáÎåÈë
¡¡¡¡ Sql Server: SELECT round(1.23456,4) value 1.23460
¡¡¡¡ Oracle: SELECT round(1.23456,4) value from dual 1.2346
6.eΪµ×µÄÃÝ
¡¡¡¡ Sql Server: SELECT Exp(1) value 2.7182818284590451
¡¡¡¡ Oracle: SELECT Exp(1) value from dual 2.71828182
7.È¡eΪµ×µÄ¶ÔÊý
¡¡¡¡ Sql Server: SELECT log(2.7182818284590451) value 1
¡¡¡¡ Oracle: SELECT ln(2.7182818284590451) value from dual; 1
8.È¡10Ϊµ×¶ÔÊý
¡¡¡¡ Sql Server: SELECT log10(10) value 1
¡¡¡¡ Oracle: SELECT log(10,10) value from dual; 1
......
sqlserver ÖÐ È«¾Ö±äÁ¿ ÊÇÒ»ÖÖÌØÊâÀàÐ͵ıäÁ¿£¬È«¾Ö±äÁ¿ÒÔ@@¿ªÍ·£¬ÊÇÓÉϵͳ¶¨ÒåµÄ¡£
@@CONNECTIONS ·µ»Ø
SQL Server
×ÔÉÏ´ÎÆô¶¯ÒÔÀ´³¢ÊÔµÄÁ¬½ÓÊý¡£
@@CURSOR_ROWS
È·¶¨µ±Æä±»µ÷ÓÃʱ¼ìË÷ÁËÓαê·ûºÏÌõ¼þµÄÐÐÊý¡£
@@DATEFIRST
Õë¶Ô»á»°·µ»Ø
SET DATEFIRST
µÄµ±Ç°Öµ£¬
SET DATEFIRST
±íʾָ¶¨µÄ
ÿÖܵĵÚÒ»Ìì¡£
@@DBTS
·µ»Øµ±Ç°Êý¾Ý¿âµÄµ±Ç°
timestamp
Êý¾ÝÀàÐ͵ÄÖµ£¬
Õâһʱ¼ä´ÁÖµÔÚÊý¾Ý¿âÖбØÐëÊÇΨһµÄ¡£
@@ERROR
·µ»ØÖ´ÐеÄÉÏÒ»¸ö
Transact-SQL
Óï¾äµÄ´íÎóºÅ£¬
Èç¹ûǰһ¸ö
Transact-SQL
Óï¾äÖ´ÐÐûÓдíÎó£¬Ôò·µ»Ø
0
¡£
@@FETCH_STATUS
·µ»ØÕë¶ÔÁ¬½Óµ±Ç°´ò¿ªµÄÈκÎÓα귢³öµÄÉÏÒ»ÌõÓαê
FETCH
Óï¾äµÄ״̬¡£
@@IDENTITY
·µ»ØÉϴβåÈëµÄ±êʶֵ¡£
@@LANGID
·µ»Øµ±Ç°Ê¹ÓõÄÓïÑԵı¾µØÓïÑÔ±êʶ·û
(ID)
¡£
@@LANGUAGE
·µ»Øµ±Ç°ËùÓÃÓïÑÔµÄÃû³Æ¡£
@@LOCK_TIMEOUT
·µ»Øµ±Ç°»á»°µÄµ±Ç°Ëø¶¨³¬Ê±ÉèÖ㨺ÁÃ룩¡£
@@MAX_CONNECTIONS
ȯ
SQL Server
ʵÀýÔÊÐíͬʱ½øÐеÄ×î´óÓû§Á¬½ÓÊý¡£
·µ»ØµÄÊýÖµ²»Ò»¶¨ ......
Ñо¿ÁËÒ»ÏÂPop3µÄÓʼþ½ÓÊÕÐÒ飬ȻºóËæÊÖдÁËÒ»¸öPop3µÄÓʼþ½ÓÊտؼþ£¡Pop3µÄÓʼþÐÒéʵ¼ÊÉÏÊǺܼòµ¥µÄ£¬ÖªµÀÄǼ¸¸öÃüÁî¾ÍÐÐÁË£¬Óë·þÎñÆ÷Ö®¼ä
µÄ½»»¥ÊÇÒ»ÎÊÒ»´ðµÃ·½Ê½£¬¿ØÖÆÆðÀ´Ò²ÈÝÒ×£¬Ïà¶Ô¶øÑÔÓʼþ¸ñʽµÄ½âÎöµ¹ÊǸü¼ÓÂé·³Ò»µã£¡ÓÚÊÇÒ²±ã˳´ø×Ž«MIMEÓʼþ¸ñʽ¸øÊìϤÁËһϣ¡×ܹé˵À´£¬¹æÂÉÐÔ±È
½ÏÇ¿£¬ÏÈ»ñÈ¡×î´óµÄ¶¥²ã¿ò¼Ü£¬È»ºó¸ù¾Ý¶¥²ã¿ò¼ÜÀ´ÅжÏÊÇ·ñÓл¹ÓÐ×Ó¿ò¼Ü£¬ÒÀ´Î¸ù¾Ý¸ø¶¨µÄ¼ä¸ô·ûºÅµü´úÏÂÀ´£¡¿´¿´ÀàÉè¼Æ£¡Ê×ÏÈÒ»¸öMIMEÊÇÒªÓÐÒ»¸öÓʼþ
Í·£¡ËùÒÔÕâ¸öÀàÊDZØÈ»µÄ£¡
ʵÏÖÁËÓʼþÍ·ÀàTDxMIMEHeader
£¬È»ºóÔÙ¿´Óʼþ¸ñʽ£¬¾ÍÊÇÊý¾Ý²¿·ÖÁË£¬Êý¾Ý²¿·Ö¾ÍÉæ¼°µ½Ç°ÃæËµµÄ¿ò¼ÜÎÊÌ⣬ÓÐMulpart/mixedµÈÕâÑùµÄ»¹ÓÐ×Ó¿ò¼ÜµÄ½á¹¹£¬Ò²Óе¥´¿µÄtext
/plainÕâÑùµÄ´¿Îı¾½á¹¹£¬¾ßÌåµÄÐÅÏ¢¶¼ÔÚÓʼþ¸ñʽµÄÍ·²¿ÓÐ˵Ã÷
£¬ÓÚÊǽ«Êý¾ÝPartÉè¼Æ³ÉÁËÒ»¸ö¼Ì³Ðģʽ£¬TDxMIMEPart×÷ΪÊý¾ÝPartµÄ»ùÀ࣬ȻºóMulpart/mixed£¬text/plainµÈÕâ
ÑùµÄ¸÷¸öÄ£¿é²¿·Ö¶¼´Ó¸ÃÀà¼Ì³Ð£¬Mulpart/mixedµÈÊÇÓÐÄÚ²¿Êý¾ÝÄ£¿éµÄ£¬ËùÒÔÕâ¸öÁíÍâ¼Ì³ÐÒ»¸ö¶àÊý¾ÝÄ£¿é»ùÀàTDxMimeMulPart£¬È»
ºóÖ»Òªº¬Óжà¸öÊý¾ÝÄ£¿éµÄÄ£¿é¶¼´ÓÕâ¸öÀà¼Ì³ÐȥʵÏÖ£¬³ý´ËÖ®Í⣬»¹ÐèÒªÒ»¸ö¸½¼þµÈÁ÷ʽÊý¾ÝµÄÁ÷Ä£¿éµÄ½âÎöÀàTDxMIMEStreamPart£¬ ......
½«Ô¶³Ì¿ØÖÆÓ¦ÓÃÓÚ½ÌѧÖУ¬ÒѳÉΪĿǰ¼ÆËã»ú»¯½ÌѧµÄÖØÒªÊֶΡ£Ò»¶¨ÓкܶàµÄÍø³æÏëÁ˽âÕâÖÖÍøÂç½Ìѧ·½Ê½µÄ±à³ÌÔÀí°É¡£ÔÚ´ËÎÒÃǾÍÒÔÒ»¸ö¼òµ¥µÄÔ¶³Ì¿ØÖƳÌÐò×÷ΪʾÀý£¬ËµÃ÷ÕâÖÖÍøÂç±à³ÌµÄ»ù±¾ÔÀí¡£±¾³ÌÐòÒÔDelphi±à³ÌΪÀý¡£
¡¡¡¡Æäʵ¸Ã³ÌÐòµÄ¹¤×÷»úÖÆºÜ¼òµ¥£¬Êܿط½ÔËÐÐÒ»¸ö³ÌÐò£¬ÓÃÓÚÕìÌý¶Ë¿Ú²¢½ÓÊÕÊý¾Ý°ü£¬¶øÖ÷¿Ø·½Í¨¹ý¶Ë¿Ú¸øÊܿط½µÄ¶Ë¿Ú·¢ËÍÊý¾Ý°ü¡£¸ù¾ÝÕâ¸öÔÀí£¬ÎÒÃDZàдÁ½¸ö³ÌÐò£¬Ò»¸öÊÇ¿ØÖÆ·½µÄ£¬¶øÁíÒ»¸öÊÇÊܿط½µÄ£¬°ÑÕâÁ½¸ö³ÌÐòÔËÐÐÔÚÁ½Ì¨²»Í¬µÄ»úÆ÷ÉÏ£¬ÊܿػúµÈ´ý¿ØÖÆ»ú·¢Ë͹ýÀ´µÄÊý¾ÝÈ»ºóÖ´ÐÐÏàÓ¦µÄ²Ù×÷(Èç±¾ÀýÖеÄÖØÆô)¡£
¡¡¡¡DelphiÖÐÓÐÁ½Àà¿Ø¼þ¿ÉÒÔʵÏÖÉÏÃæµÄÄ¿µÄ¡£Ò»ÀàÊÇ¿ØÖÆ·½Ê¹ÓÃClientSocket£¬Êܿط½Ê¹ÓÃServerSocket(¾ùÔÚInternetÒ³)£¬ÁíÒ»ÀàÊÇË«·½¶¼Ê¹ÓÃNMUDP(ÔÚFastNetÒ³)¡£ÎÒÃÇÖªµÀÍøÂç´«Êä¶¼ÊDz»¿É¿¿µÄ£¬Ò²¾ÍÊÇ˵´«ÊäµÄÊý¾ÝÓпÉÄܶªÊ§£¬¶øÕâÁ½Àà¿Ø¼þµÄÇø±ðÊÇǰÕßʹÓÃTCP(Transfer Control Protocol£¬´«Êä¿ØÖÆÐÒé)¡£TCPÐÒéÊÇÃæÏòÁ¬½Ó,ÿ´ÎË«·½½¨Á¢Á¬½Ó(»ò¶Ï¿ª)ʱÐè¾¹ýÈý´ÎÎÕÊÖ,½ÏΪºÄʱ£¬µ«Êý¾Ý´«Êä¿É¿¿£»¶øºóÕßʹÓÃUDP(User Datagram Protocol£¬Óû§±¨ÎÄÐÒé)£¬ËüÊÇÃæÏòÎÞÁ¬½ÓµÄ£¬·¢³öÊý¾Ý²»Ðè¶Ô·½È·ÈÏ£¬ÕâÑùËٶȱÈTCP¿ì£¬µ«Êý¾ÝÓпÉÄܶªÊ§£¬Ò ......
DelphiºÍC++Êý¾ÝÀàÐͶÔÕÕ±í
Delphi ×Ö³¤/ÖµÓò C++
ShortInt 8λÓзûºÅÕûÐÍ signed char
SmallInt 16λÓзûºÅÕûÐÍ short
LongInt 32λÓзûºÅÕûÐÍ int
Byte 8λÎÞ·ûºÅÕûÐÍ &nb ......
DelphiºÍC++Êý¾ÝÀàÐͶÔÕÕ±í
Delphi ×Ö³¤/ÖµÓò C++
ShortInt 8λÓзûºÅÕûÐÍ signed char
SmallInt 16λÓзûºÅÕûÐÍ short
LongInt 32λÓзûºÅÕûÐÍ int
Byte 8λÎÞ·ûºÅÕûÐÍ &nb ......