ÀàËÆ 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 ÓÐʲô×÷Óà Èç¹ûÄãÔ¸Òâÿ·Ò»
Ïà¹ØÎÊ´ð£º
²»ÖªµÀÊÇʲôÔÒòʧ°ÜÁË ÈçÏÂͼËùʾ£º Èç¹ûͼƬ˵µÁÁ´¿ÉÒÔ½øÈëÒÔÏÂÁ´½Ó£º http://hiphotos.baidu.com/z789017890/pic/item/890d6cf0c6996482a40f5282.jpg ÏȸÐлÄãµÄ°ïÖú~~ Á´½ÓÒ²µÁÁ´ ......
ÎÒʹÓÃÁËsharpdevelop×öѧϰ£¡ÔÚdata¹¤¾ß¿¨ÖÐÖ»ÓÐÁÈÁȼ¸¸ö Óûä¯ÀÀmssqlÊý¾Ý¿âtestÖÐijһÕÅ±í¡£Ã²ËÆÃ»·¢ÏÖɶ¿Ø¼þ¡£ÓÃÁËviewºÍsourceµÄ¡£ ûÓÐÉèÖõĵط½£¬¿¨ÔÚÕâÀï´ó¸ÅºÃ¼¸¸öСʱÁË¡£baidugooleÎÞ¹û¡£ ......
ÒªÈçºÎ¶ÁÐ´ÄØ?ûΪû²Ù×÷¹ý.. ÏÖÔÚÒª°ÑÕû¸öÍøÒ³µÄÄÚÈÝ´æ´¢µ½Ò»¸ö×Ö¶ÎÀï.. ³ýÁËNTextÏë²»µ½Ê²Ã´ÀàÐÍÁË.. »òÕß´ó¼ÒÓÐûÓÐʲôºÃ°ì·¨? ¿ÉÒÔʹÓÃImageÀàÐÍ¡£ ·½·¨²Î¿¼£º var MS: TMemoryStrea ......
»áÔ±ID£ºws_hgo ÉêÇë°æÃæ£ºSQL ServerÒÉÄÑÎÊÌâ ÉêÇë°æÖ÷ÀíÓÉ£ºÏ£ÍûÔÚCSDN¾¡¿ÉÄܵİïÖú´ó¼Ò,Ï£ÍûÄܹ»ºÍ´ó¼ÒÒ»ÆðÌá¸ßMSSQL¼¼Êõ ƽ¾ùÉÏÍøÊ±¼ä(Сʱ/Ìì)£º>12Сʱ ÊÇ·ñµ£Èιý±¾ÉçÇø»òÕ߯äËûÉçÇøÏà¹ØÖ ......
¸÷λ´óÏÀ £¬ÎÒ½ñÌì×öÁ˸öjob£¬sqlÊÇ exec proc_showresult. ¿É¾ÍÊDz»ÄÜÖ´ÐÐ £¬È»ºóÎÒ°ÉÕâ¸ösql»»³É select 1¡£¾ÍûÎÊÌ⣬ÕâÊÇʲôÔÒò°¡ Çë¸ßÊÖÖ¸½Ì ´æ´¢¹ý³ÌÓвÎÊýû?? Ò²ÐíÊÇÖ´ÐÐÁË,Äãû ......