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

ÀàËÆ 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 ÓÐʲô×÷ÓÃ

Èç¹ûÄãÔ¸Òâÿ·­Ò»


Ïà¹ØÎÊ´ð£º

MSSQL 2005 Êý¾Ý¿â»Ö¸´Ê§°Ü

²»ÖªµÀÊÇʲôԭÒòʧ°ÜÁË

ÈçÏÂͼËùʾ£º


Èç¹ûͼƬ˵µÁÁ´¿ÉÒÔ½øÈëÒÔÏÂÁ´½Ó£º
http://hiphotos.baidu.com/z789017890/pic/item/890d6cf0c6996482a40f5282.jpg

ÏȸÐлÄãµÄ°ïÖú~~
Á´½ÓÒ²µÁÁ´ ......

ÓÃvisual studioµÄÅóÓѽøÅ¶£¡mssqlÎÊÌ⣡

ÎÒʹÓÃÁËsharpdevelop×öѧϰ£¡ÔÚdata¹¤¾ß¿¨ÖÐÖ»ÓÐÁÈÁȼ¸¸ö


Óûä¯ÀÀmssqlÊý¾Ý¿âtestÖÐijһÕÅ±í¡£Ã²ËÆÃ»·¢ÏÖɶ¿Ø¼þ¡£ÓÃÁËviewºÍsourceµÄ¡£
ûÓÐÉèÖõĵط½£¬¿¨ÔÚÕâÀï´ó¸ÅºÃ¼¸¸öСʱÁË¡£baidugooleÎÞ¹û¡£ ......

ÈçºÎ¶ÁдmssqlÖеÄNTextÀàÐ͵ÄÊý¾Ý°¡?

ÒªÈçºÎ¶ÁÐ´ÄØ?ûΪû²Ù×÷¹ý..
ÏÖÔÚÒª°ÑÕû¸öÍøÒ³µÄÄÚÈÝ´æ´¢µ½Ò»¸ö×Ö¶ÎÀï..
³ýÁËNTextÏë²»µ½Ê²Ã´ÀàÐÍÁË..
»òÕß´ó¼ÒÓÐûÓÐʲôºÃ°ì·¨?
¿ÉÒÔʹÓÃImageÀàÐÍ¡£
·½·¨²Î¿¼£º
var
  MS: TMemoryStrea ......

ÉêÇëMSSQLÒÉÄÑÎÊÌâ°æ°æÖ÷,Ï£Íû´ó¼ÒÖ§³Ö!

»áÔ±ID£ºws_hgo
ÉêÇë°æÃæ£ºSQL ServerÒÉÄÑÎÊÌâ
ÉêÇë°æÖ÷ÀíÓÉ£ºÏ£ÍûÔÚCSDN¾¡¿ÉÄܵİïÖú´ó¼Ò,Ï£ÍûÄܹ»ºÍ´ó¼ÒÒ»ÆðÌá¸ßMSSQL¼¼Êõ
ƽ¾ùÉÏÍøÊ±¼ä(Сʱ/Ìì)£º>12Сʱ
ÊÇ·ñµ£Èιý±¾ÉçÇø»òÕ߯äËûÉçÇøÏà¹ØÖ ......

mssql job²»ÄÜÖ´ÐÐ

¸÷λ´óÏÀ  £¬ÎÒ½ñÌì×öÁ˸öjob£¬sqlÊÇ exec  proc_showresult.
¿É¾ÍÊDz»ÄÜÖ´ÐÐ £¬È»ºóÎÒ°ÉÕâ¸ösql»»³É select 1¡£¾ÍûÎÊÌ⣬ÕâÊÇʲôԭÒò°¡  Çë¸ßÊÖÖ¸½Ì
´æ´¢¹ý³ÌÓвÎÊýû??
Ò²ÐíÊÇÖ´ÐÐÁË,Äãû ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ