Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

SQLite²Ù×÷Ö¸ÄÏ(SQLite version 3.6.21)

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 ³£Óú¯Êý±È½Ï


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 ³£Óú¯Êý±È½Ï


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 һЩȫ¾Ö±äÁ¿

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
ʵÀýÔÊÐíͬʱ½øÐеÄ×î´óÓû§Á¬½ÓÊý¡£
·µ»ØµÄÊýÖµ²»Ò»¶¨ ......

DelphiʵÏÖµÄMIMEÓʼþ¸ñʽ½âÎöÀà¿â

Ñо¿ÁËÒ»ÏÂPop3µÄÓʼþ½ÓÊÕЭÒ飬ȻºóËæÊÖдÁËÒ»¸öPop3µÄÓʼþ½ÓÊտؼþ£¡Pop3µÄÓʼþЭÒéʵ¼ÊÉÏÊǺܼòµ¥µÄ£¬ÖªµÀÄǼ¸¸öÃüÁî¾ÍÐÐÁË£¬Óë·þÎñÆ÷Ö®¼ä
µÄ½»»¥ÊÇÒ»ÎÊÒ»´ðµÃ·½Ê½£¬¿ØÖÆÆðÀ´Ò²ÈÝÒ×£¬Ïà¶Ô¶øÑÔÓʼþ¸ñʽµÄ½âÎöµ¹ÊǸü¼ÓÂé·³Ò»µã£¡ÓÚÊÇÒ²±ã˳´ø×Ž«MIMEÓʼþ¸ñʽ¸øÊìϤÁËһϣ¡×ܹé˵À´£¬¹æÂÉÐÔ±È
½ÏÇ¿£¬ÏÈ»ñÈ¡×î´óµÄ¶¥²ã¿ò¼Ü£¬È»ºó¸ù¾Ý¶¥²ã¿ò¼ÜÀ´ÅжÏÊÇ·ñÓл¹ÓÐ×Ó¿ò¼Ü£¬ÒÀ´Î¸ù¾Ý¸ø¶¨µÄ¼ä¸ô·ûºÅµü´úÏÂÀ´£¡¿´¿´ÀàÉè¼Æ£¡Ê×ÏÈÒ»¸öMIMEÊÇÒªÓÐÒ»¸öÓʼþ
Í·£¡ËùÒÔÕâ¸öÀàÊDZØÈ»µÄ£¡
ʵÏÖÁËÓʼþÍ·ÀàTDxMIMEHeader
£¬È»ºóÔÙ¿´Óʼþ¸ñʽ£¬¾ÍÊÇÊý¾Ý²¿·ÖÁË£¬Êý¾Ý²¿·Ö¾ÍÉæ¼°µ½Ç°ÃæËµµÄ¿ò¼ÜÎÊÌ⣬ÓÐMulpart/mixedµÈÕâÑùµÄ»¹ÓÐ×Ó¿ò¼ÜµÄ½á¹¹£¬Ò²Óе¥´¿µÄtext
/plainÕâÑùµÄ´¿Îı¾½á¹¹£¬¾ßÌåµÄÐÅÏ¢¶¼ÔÚÓʼþ¸ñʽµÄÍ·²¿ÓÐ˵Ã÷
£¬ÓÚÊǽ«Êý¾ÝPartÉè¼Æ³ÉÁËÒ»¸ö¼Ì³Ðģʽ£¬TDxMIMEPart×÷ΪÊý¾ÝPartµÄ»ùÀ࣬ȻºóMulpart/mixed£¬text/plainµÈÕâ
ÑùµÄ¸÷¸öÄ£¿é²¿·Ö¶¼´Ó¸ÃÀà¼Ì³Ð£¬Mulpart/mixedµÈÊÇÓÐÄÚ²¿Êý¾ÝÄ£¿éµÄ£¬ËùÒÔÕâ¸öÁíÍâ¼Ì³ÐÒ»¸ö¶àÊý¾ÝÄ£¿é»ùÀàTDxMimeMulPart£¬È»
ºóÖ»Òªº¬Óжà¸öÊý¾ÝÄ£¿éµÄÄ£¿é¶¼´ÓÕâ¸öÀà¼Ì³ÐȥʵÏÖ£¬³ý´ËÖ®Í⣬»¹ÐèÒªÒ»¸ö¸½¼þµÈÁ÷ʽÊý¾ÝµÄÁ÷Ä£¿éµÄ½âÎöÀàTDxMIMEStreamPart£¬ ......

delphiÔõÑùʵÏÖÔ¶³Ì¿ØÖÆ(ת)

½«Ô¶³Ì¿ØÖÆÓ¦ÓÃÓÚ½ÌѧÖУ¬ÒѳÉΪĿǰ¼ÆËã»ú»¯½ÌѧµÄÖØÒªÊֶΡ£Ò»¶¨ÓкܶàµÄÍø³æÏëÁ˽âÕâÖÖÍøÂç½Ìѧ·½Ê½µÄ±à³ÌÔ­Àí°É¡£ÔÚ´ËÎÒÃǾÍÒÔÒ»¸ö¼òµ¥µÄÔ¶³Ì¿ØÖƳÌÐò×÷ΪʾÀý£¬ËµÃ÷ÕâÖÖÍøÂç±à³ÌµÄ»ù±¾Ô­Àí¡£±¾³ÌÐòÒÔDelphi±à³ÌΪÀý¡£
¡¡¡¡Æäʵ¸Ã³ÌÐòµÄ¹¤×÷»úÖÆºÜ¼òµ¥£¬Êܿط½ÔËÐÐÒ»¸ö³ÌÐò£¬ÓÃÓÚÕìÌý¶Ë¿Ú²¢½ÓÊÕÊý¾Ý°ü£¬¶øÖ÷¿Ø·½Í¨¹ý¶Ë¿Ú¸øÊܿط½µÄ¶Ë¿Ú·¢ËÍÊý¾Ý°ü¡£¸ù¾ÝÕâ¸öÔ­Àí£¬ÎÒÃDZàдÁ½¸ö³ÌÐò£¬Ò»¸öÊÇ¿ØÖÆ·½µÄ£¬¶øÁíÒ»¸öÊÇÊܿط½µÄ£¬°ÑÕâÁ½¸ö³ÌÐòÔËÐÐÔÚÁ½Ì¨²»Í¬µÄ»úÆ÷ÉÏ£¬ÊܿػúµÈ´ý¿ØÖÆ»ú·¢Ë͹ýÀ´µÄÊý¾ÝÈ»ºóÖ´ÐÐÏàÓ¦µÄ²Ù×÷(Èç±¾ÀýÖеÄÖØÆô)¡£
¡¡¡¡DelphiÖÐÓÐÁ½Àà¿Ø¼þ¿ÉÒÔʵÏÖÉÏÃæµÄÄ¿µÄ¡£Ò»ÀàÊÇ¿ØÖÆ·½Ê¹ÓÃClientSocket£¬Êܿط½Ê¹ÓÃServerSocket(¾ùÔÚInternetÒ³)£¬ÁíÒ»ÀàÊÇË«·½¶¼Ê¹ÓÃNMUDP(ÔÚFastNetÒ³)¡£ÎÒÃÇÖªµÀÍøÂç´«Êä¶¼ÊDz»¿É¿¿µÄ£¬Ò²¾ÍÊÇ˵´«ÊäµÄÊý¾ÝÓпÉÄܶªÊ§£¬¶øÕâÁ½Àà¿Ø¼þµÄÇø±ðÊÇǰÕßʹÓÃTCP(Transfer Control Protocol£¬´«Êä¿ØÖÆÐ­Òé)¡£TCPЭÒéÊÇÃæÏòÁ¬½Ó,ÿ´ÎË«·½½¨Á¢Á¬½Ó(»ò¶Ï¿ª)ʱÐè¾­¹ýÈý´ÎÎÕÊÖ,½ÏΪºÄʱ£¬µ«Êý¾Ý´«Êä¿É¿¿£»¶øºóÕßʹÓÃUDP(User Datagram Protocol£¬Óû§±¨ÎÄЭÒé)£¬ËüÊÇÃæÏòÎÞÁ¬½ÓµÄ£¬·¢³öÊý¾Ý²»Ðè¶Ô·½È·ÈÏ£¬ÕâÑùËٶȱÈTCP¿ì£¬µ«Êý¾ÝÓпÉÄܶªÊ§£¬Ò ......

DelphiºÍC++Êý¾ÝÀàÐͶÔÕÕ±í

DelphiºÍC++Êý¾ÝÀàÐͶÔÕÕ±í
Delphi        ×Ö³¤/ÖµÓò                                C++
ShortInt    8λÓзûºÅÕûÐÍ                        signed char
SmallInt    16λÓзûºÅÕûÐÍ                        short
LongInt        32λÓзûºÅÕûÐÍ                        int
Byte        8λÎÞ·ûºÅÕûÐÍ            &nb ......

DelphiºÍC++Êý¾ÝÀàÐͶÔÕÕ±í

DelphiºÍC++Êý¾ÝÀàÐͶÔÕÕ±í
Delphi        ×Ö³¤/ÖµÓò                                C++
ShortInt    8λÓзûºÅÕûÐÍ                        signed char
SmallInt    16λÓзûºÅÕûÐÍ                        short
LongInt        32λÓзûºÅÕûÐÍ                        int
Byte        8λÎÞ·ûºÅÕûÐÍ            &nb ......
×ܼǼÊý:40319; ×ÜÒ³Êý:6720; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [3953] [3954] [3955] [3956] 3957 [3958] [3959] [3960] [3961] [3962]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ