select top 3 stuid from pagesize where stuid not in (select top 3 stuid from pagesize order by id asc) order by id ascÕâÀïµÄ·ÖÒ³sqlÓï¾äΪʲôҪ¼ÓÉÏÅÅÐòÄØ£¿²»ÅÅÐò²»ÐÐÂð£¿ÎÒ¿´µ½ºÜ¶àsqlÓï¾ä·ÖÒ³´úÂëÔÚÀ¨ºÅÍâÃæºÍÀïÃæ¶¼ÓÐÅÅÐò£¡ÄܾßÌå˵ÏÂʲôÂ𣿻òÕßÓÐÆäËûµÄÀý×ÓÀ´ËµÒ»Ï£¡£¿£¿
id stuid
1 1
2 2
3 2
......
ÎÒÔÚ×öÒ»¸ö¸öÈ˵ÄÐ¡ÍøÕ¾£¬ÓõÄÊÇSQL±íÀ´´æ´¢Êý¾ÝµÄ¡£ÎÒ°ÑÐÂÎÅÄÚÈÝÖ±½Ó´æ´¢ÔÚtext×Ö¶ÎÖУ¬ÔÚÒ³ÃæÏÔʾµÄʱºòÎÄ×Ö¶¼½ÓÔÚÒ»ÆðÁË£¬Ã»ÓжÎÂäÁË¡£
´ó¼ÒÓÐʲôºÃµÄ·½·¨£¬ÌáЩÒâ¼û¡£
´æ½øÈ¥²»»á¶ªÊ§¸ñʽµÄ£¬
¹Ø¼üÊÇÄãÔõôÏÔʾµÄ£¿Äã¿ÉÒÔµ÷ÊÔÏ£¬¿´²éѯ³öÀ´£¬ÓÐûÓдø\n\rÕâÑùµÄ¸ñʽÔÚÄÚÈÝÀïÃæ
Ôõô´æ¾ÆÔõôÏÔʾ
×¢ÒâÌæ»»Ò»Ð©\ ......
declare @a varchar(50)
set @a = '2010/02/02¡«2010/02/05'
ÎÒÏëÒªÊä³öÁ½¸ö×Ö·û´®£¬·Ö±ðÊÇ
'2010/02/02¡¯ºÍ¡®2010/02/05'
ÇëÎÊsqlÔõôʵÏÖ£¬×îºÃ²»Òª½ØÈ¡×Ö·û´®µÄÄÇÖÖ
²»½ØÈ¡ÄÇÄÒ¸ö°ì°¡£¿
Äܲ»Äܸù¾Ý ¡°¡«¡±
Õâ¸ö·ûºÅÀ´·Ö¿ª
SQL code:
declare @a varchar(50)
set @a = '2010/02/02¡«2010/02/05'
declar ......
ÎÒÏëʵÏÖÒ»¸ö¶þ¼¶Áª¶¯£¬Êý¾ÝÔ´ÊÇxml,¿É·¢ÏÖÓкܶàajax¼¼Êõ£¬²»ÖªµÀÓÃʲôºÃ£¿
updatepanel²»ÊÇͦºÃµÄÂð£¿ÔõôÌýÄĸö»ìµ°Ëµ²»ÒªÓá£
jquery
<div>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
......
ÎÒÔÚ±¾µØ²âÊԺõÄÍøÕ¾,ÉÏ´«µ½ÍøÕ¾ÉÏÔõôµãÕâ¸öÒ³Ãæ,ÔÙµãÆäËüµÄÒ³Ãæ¾Í³ö´í,ûÏÔʾ,¾ÍºÃÏñÍøÒ³´ò²»¿ªÒ»Ñù,µãÆäËüµÄÒ³Ãæ¾ÍûÓÐÎÊÌâ,ÊÇ·þÎñÆ÷ÎÊÌâÂð? ÎÒ»»Ò»Ì¨·þÎñÆ÷Ò²ÊÇÕâÑù°¡,ÄǸöÒ³ÃæµÄ´úÂëÈçÏÂ,˰ïÎÒ¿´¿´,ÎÒÕæµÄ²»ÖªµÀÊÇʲôÎÊÌâ,ŪÁËÁ½²ÎÌ컹ÊÇû½á¹û,²»ÖªµÀÓÐûÓÐľÂí,ÒòΪ²»ÒªµãÕâ¸öÒ³Ãæ¾Í²»»á³öÏÖÕâÎÊÌâÁË,ÔÚ´Ëлл´ó¼ ......
ÎÒÊÇÐÂÊÖ,Ò»¸ö×öºÃµÄ³ÌÐòզô·¢²¼µ½IISÉÏÃæÈ¥°¡£¿
×îºÃ˵Ïêϸһµã£¡
IISÖÐÅäÖÃÐéÄâĿ¼»òÍøÕ¾
Ñ¡ÔñÏîÄ¿ÓÒ¼ü·¢²¼ÍøÕ¾£¬Îļþ¸´ÖƵ½ÐéÄâĿ¼µÈÖлòʹÓÃ
WebDeployment Project
ÒýÓÃ
IISÖÐÅäÖÃÐéÄâĿ¼»òÍøÕ¾
Ñ¡ÔñÏîÄ¿ÓÒ¼ü·¢²¼ÍøÕ¾£¬Îļþ¸´ÖƵ½ÐéÄâĿ¼µÈÖлòʹÓÃ
WebDeployment Project
up
ÓÒ¼ü·¢²¼ÍøÕ¾£¬Ñ¡ÔñÄ¿ ......