ÀàËÆ mssql select top ...µÄʵÏÖ
ÔÚms sqlserverÖУ¬È¡Âú×ãÌõ¼þµÄǰ¼¸ÐпÉÒÔʹÓÃselect topÓï¾ä£¬µ«ÔÚoracleÖв¢Ã»ÓÐÕâÑùµÄÓï¾ä£¬ ÎÒ´ÓÍøÉÏ¿´µ½ÁËÒ»ÖÖʵÏÖ select * (select * from talbename) where rownum <=100 order by rownum asc ÕâÑùµÄÈ·¿ÉÒÔʵÏÖÓëselect top ÏàͬµÄЧ¹û ²»¹ýÎÒÏëÇëÎÊ£¬ÕâÌõÓï¾äÊÇÏȲéÕÒ³öËùÓнá¹û£¬È»ºóÔÙ·µ»ØÇ°100ÐУ¿ »¹ÊDzéÕÒµ½·ûºÏÌõ¼þµÄ100ÐмǼ¾ÍÍ£Ö¹²éÕÒ£¿
order by asc...»ÉßÌí×ãÁ˰ɡ£×Ó²éѯÀïÃæÒª¼ÓÉÏÅÅÐò µ±È»Òª¼ìË÷ËùÓеĽá¹û£¬·ñÔòÔõô֪µÀÄÇ100Ìõ¼Ç¼¾ÍÊÇ·ûºÏÌõ¼þµÄ àÅ£¬ÍâÃæµÄorderby ËÆºõÊÇûÓ㬠ÎÒʵ¼ÊʹÓõÄʱºòÓõÄÊÇÏÂÃæµÄÓï¾ä select * (select * from talbename order by UUID) where rownum <=100 ʵ¼ÊÉÏÎÒÊÇÏëÔÚ·ÖÒ³ÉÏʹÓã¬Ã¿Ò³²é100Ìõ£¬Óû§°´ÏÂһҳʱºòÔÙ²é100Ìõ£¬¶ø²»ÊÇÒ»´ÎÈ«²é³öÀ´ °´ÕÕ1¥˵µÄ£¬ËƺõÕâÌõÓï¾ä´ï²»µ½ÎÒÏëÒªµÄЧ¹û°¡ÒýÓà select * from (select a.*,row_number()over(order by uuid)rn from tablename a) where rn>=beginnum and rn <=endnum order by rn ˵ʵ»°£¬Ã»¿´¶® ²»¹ýÎÒ²éÁËÏ rownumµÄ½âÊÍ£¬ÕâÊǸöαÁУ¬±êÃ÷µ±Ç°¼Ç¼ÊDzéѯµ½µÄµÚ¼¸Ìõ£¬ Èç¹ûÕâÑùµÄ»°£¬ select * from table where rumber <= 100 ¾Í¿ÉÒÔ²éѯ³öǰ100Ìõ È»ºóÎÒ¿ÉÒԼǼϵ±Ç°µÚ100ÌõµÄ¼Ç¼µÄÖеÄID,ÒÔºóÿһҳ£¬Ö»Òª select * from table where rumber <= 100 and ID>LastID ÕâÑù¾Í¿ÉÒÔÂú×ãÎÒµÄÐèÇóÁË ÕâÑùµÄ»° £¬ÎÒʵÔÚûÓп´³öǶÌ×select ÓÐʲô×÷Óà Èç¹ûÄãÔ¸Òâÿ·Ò»
Ïà¹ØÎÊ´ð£º
ÒªÈçºÎ¶ÁÐ´ÄØ?ûΪû²Ù×÷¹ý.. ÏÖÔÚÒª°ÑÕû¸öÍøÒ³µÄÄÚÈÝ´æ´¢µ½Ò»¸ö×Ö¶ÎÀï.. ³ýÁËNTextÏë²»µ½Ê²Ã´ÀàÐÍÁË.. »òÕß´ó¼ÒÓÐûÓÐʲôºÃ°ì·¨? ¿ÉÒÔʹÓÃImageÀàÐÍ¡£ ·½·¨²Î¿¼£º var MS: TMemoryStrea ......
Á½¸ö±í ±íA UserID,Info1,Info2,¼°ÆäËû¼¸¸ö×Ö¶Î ±íB UserID,Info1,Info2 ±íAÀïÃæµÄÊý¾Ý£¬±íBÀïÃæ²»Ò»¶¨´æÔÚ ÈçºÎÊä³öÕâÖÖ½á¹û ÁÐ UserID,±íA Info1£¬±íA Info2£¬±íB Info1,±íB ......
MSSQL´¥·¢Æ÷¿ÉÒÔ´¥·¢Ó¦ÓóÌÐòÄÚµÄʼþÂð£¿ÎÒÏëÓÃc#¿ª·¢Ê±ÊµÊ±µÃµ½Êý¾Ý¿âÌí¼ÓÐ޸ĵÈʼþÐÅÏ¢£¬²»ÖªÄܲ»ÄÜÓÃÊý¾Ý¿âµÄ´¥·¢Æ÷£¬»¹ÊÇÐèÒªÓÃtimer×Ô¼º¶¨Ê±È¥¼ì²éÊý¾Ý¿â£¬Ð»Ð»´ó¼Ò£¡ ÐèÒªÕâô×öÂ𣿠¶¨Ê±Æ÷ÀÏÊÇÈ¥¼ì ......
RT ºÃÏñ¿¼MSSQLÖ¤·ÖºÃ¼¸ÖÖŶ? ×ÉѯÏ ÓÐʲôÏà¹Ø×ÊÁÏô£¿ Õâ¸öÕæ²»Çå³þ£¬°ï¶¥°É µ±È»ÊÇMICROSOFTµÄMCSEÁË .. °ï¶¥ °ï¶¥Ï°ɡ£¡£ MS SQL ÈÏÖ¤ 2000:mcdba 2005:·ÖÈý¸öϵÁÐ ¹ ......
ÎÒÉè¼ÆµÄ Óû§ÐÅÏ¢±í ³±íÊý¾Ý±í ÀúÊ·³±íÊý¾Ý±í ÎÒµÄÏë·¨ÊÇ Ã¿Ô³õ ϵͳ×Ô¶¯ÔÚ ³±íÊý¾Ý±íÖÐÉú²ú ÓëÓû§¹ØÁªµÄÊý¾Ý ÓÃÓÚ³±íÔ±µÄ¼È룬µ±³±íԱȫ²¿Â¼Èëºó °ÑÊý¾ÝÈ«²¿¸´ÖƵ½ÀúÊ·±íÖРͨʱ ......