Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓÃVFP9.0ºÍSQL2000¹¹½¨C/S°æ±¾µÄÈËʹÜÀíϵͳ

±¾ÊµÀýÒ»Ì×ÈËʹÜÀíϵͳ£º¿ª·¢¹¤¾ßΪVFP9.0¡¢SQL2000¡¢EXCEL;ʹÓÃÁËAdobe PhotoshopƽÃæÉè¼ÆÈí¼þ£¬²ÉÓÃÁËSPT´©Í¸¼¼Êõ£¬µ÷ÓÃÁËAPIº¯Êý£¬ÊµÏÖÁ˶Ôϵͳʱ¼äµÄͳһ¿ØÖÆ¡¢¶ÔDNSµÄ´úÂë¿ØÖÆ¡¢¶ÔÓòÃû½âÎöµÄÓ¦Ó㬵ȵÈ
ÔΣ¬ÔõôÉÏ´«£¬£¨°üº¬Ô´Âëδ±àÒëµÄ£©ÏëÒªµÄ¸øÎÒ·¢E-MAIL:zhao@tom.com


Ïà¹ØÎĵµ£º

sql²éѯµÄÎÞÏÞ·ÖÀà²éѯµÄÉè¼Æ

×î½üÔÚÕÒÒ»´Îsql²éѯµÄÎÞÏÞ·ÖÀà²éѯµÄÉè¼Æ£¬ÍøÉÏÕÒÁËÒ»ÏÂÕâ¸öÊý¾Ý±íµÄÉè¼ÆºÜÓÐÌØÉ«£¬
²»Óõݹ飬ÒÀ¿¿¸ö¼òµ¥SQLÓï¾ä¾ÍÄÜÁгö²Ëµ¥£¬¿´¿´Õâ¸öÊý¾Ý±íÔõôÉè¼ÆµÄ£¬²¢¶ÔÏÂÃæµÄÊý¾Ý±í½á¹¹µÄ²éѯ½øÐзÖÎö.
Êý¾Ý¿â×ֶδó¸ÅÈçÏ£º
-----------------------------------------------------------------------------------
id  ......

ÔÚSQLÓï¾ä²éѯ½á¹ûÖмÓÈë×ÔÔö³¤ÁÐ

Óï¾ä£ºselect rank() over(Order By ±íµÄÖ÷¼ü Desc) As UID ,ÆäËûÁÐ from ±í
˵Ã÷£ºrankº¯Êý
×÷Óãº
·µ»ØÖ¸¶¨Ôª×éÔÚÖ¸¶¨¼¯ÖеÄÅÅÃû£¨ÅÅÃû´Ó 1 ¿ªÊ¼£©
Rank(Tuple_Expression, Set_Expression [ ,Numeric Expression ] )
²ÎÊý£º
Tuple_Expression
Ò»¸öÓÐЧµÄ¶àά±í´ïʽ (MDX) Ôª ......

SQLÓï¾äÓÅ»¯·½·¨30Àý

ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ­³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle
HINTµÄÓ÷¨£º
1. /*+ALL_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='SCOTT'; 2. /*+FIRST_ROWS*/
±íÃ÷¶ÔÓï¾ä¿ ......

c/c++ÖеÄλ²Ù×÷


C\C++Ö§³Ö±È½ÏµÍ½×µÄλÔËË㣬ÔÚÊÇÖÚÈ˽ÔÖªµÄÁË¡£Ã¿±¾C\C++µÄ½Ì¿ÆÊ鶼»á˵µ½Õⲿ·ÖµÄÄÚÈÝ£¬²»¹ý¶¼ºÜ¼òÂÔ£¬ÎÒÏë»áÓкܶàÈ˲»ÖªµÀλÔËËãÓÃÔÚʲôµØ·½¡£Õâ¸öÌû×ӾͼòÂÔ˵˵λÔËËãµÄÓô¦£¬¸ü½øÒ»²½µÄÓ÷¨Òª´ó¼Ò×Ô¼ºÈ¥Ìå»á¡£¶øÖ÷Ҫ˵µÄÊDzÙ×÷±êÖ¾Öµ·½Ãæ¡£
 /****************************************/
#define BTI ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ