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

ÇóSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

Óбí
¶ùͯÐÕÃû ³öÉúÈÕÆÚ ½ÓÖÖÒßÃç ½ÓÖÖʱ¼ä
Àî¸ÖÑó 2010-01-29 A1B1F1F2 101U104O101U1033
¿õºÆÓî 2010-01-26 A1B1F1 101Q104N101Q
³Ì³É 2010-01-03 A1B1F1F2 1013103M1013
½¯ÁÖ¾ù 2010-01-03 A1B1B2F1F2{1 1014103M104M10141024104M
ÉòÑîºÆ 2010-01-03 A1B1B2F1F2{1 1014103N104N10141025104N
³ÌÁ¼Ó¢ 2010-01-03 A1B1B2F1F2{1 1014103M104L10141025104L
ÂÞ¿¡Ãú 2010-01-01 A1B1B2F1F2{1 1014103L104N10141025104N
Åí¿ÉȽ 2010-01-03 A1B1B2F1F2{1 1013103L104M10131026104M

±íÖнÓÖÖÒßÃçÖÐÁ½¸ö×Ö·ûΪһ×飬A1ΪAÖÖÒßÃçµÚ1Õë A1¶ÔÓ¦½ÓÖÖʱ¼ä£¨101U£©Ëĸö×Ö·ûΪһ×飬101U£¨10±íʾ2010Ä꣬1±íʾ1ÔÂ,UΪ(ÈýÊ®¶þ½øÖÆ)±íʾ29ÈÕ¡£
ÈçºÎÓÃÒ»ÌõÓï¾äÇóµÃA1 B1 B2 F1 F2 {1 ÔÚ½ÓÖÖʱ¼ä£¨2010Äê4ÔÂ1ÈÕ—4ÔÂ30)ÖеļǼÊý

¼È½á¹û£º
A1£º0
B1£º3
B2£º5
F1£º0
F2£º0
{1£º5

Â¥Ö÷°ïÄ㶥һϰɣ¬ÏÈÏëÒ»ÏÂ

¼ÈÈ»Éè¼ÆÁËÕâÑù½ô´Õ»ÞɬµÄ±àÂë·½°¸£¬¾Í¿Ï¶¨ÓнâÂë·½·¨¡£

Ö»ÊÇÕâʵÔÚ²»ÊÇʲôºÃµÄÉè¼Æ£º
1. ½ÚÊ¡ÕâÒ»µã¿Õ¼ä£¬´úÂëÊǼÆËãÁ¿±¶Ôö£¬µÃ²»³¥Ê§¡£
2. ²»ÄܼǼ½ÓÖÖÒßÃçµÄÀúÊ·¼Ç¼¡£

µ¹²»·ÁרÃżÓÒ»ÕŽÓÖÖÒßÃç±í£¨¶ùͯÐÕÃû£¬ÒßÃçÖÖÀ࣬µÚ¼¸Õ룬½ÓÖÖʱ¼ä£©£¬ÆäÖÐÒÔ¼ÓÏ»®ÏßµÄ×Ö¶ÎΪÖ÷¼ü¡£

LZµÄÔ­ÓÐÎÊÌ⣬»ù±¾ÉÏÒ²ÊǰÑԭʼ±í½âÂë³ÉÕâÖÖ¸ñʽ£¬ÔÙÓþۼ¯º¯Êýͳ¼Æ¡£

ÒýÓÃ
¼ÈÈ»Éè¼ÆÁËÕâÑù½ô´Õ»ÞɬµÄ±àÂë·½°¸£¬¾Í¿Ï¶¨ÓнâÂë·½·¨¡£

Ö»ÊÇÕâʵÔÚ²»ÊÇʲôºÃµÄÉè¼Æ£º
1. ½ÚÊ¡ÕâÒ»µã¿Õ¼ä£¬´úÂëÊǼÆËãÁ¿±¶Ôö£¬µÃ²»³¥Ê§¡£
2. ²»ÄܼǼ½ÓÖÖÒßÃçµÄÀúÊ·¼Ç¼¡£


Ïà¹ØÎÊ´ð£º

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

sqlÓï¾äÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......

ASPÒ³ÃæÎÞ·¨´ò¿ªÇóÖú£¡ - MS-SQL Server / »ù´¡Àà

¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......

asp wap sqlÓï¾äÖлñÈ¡µÄºº×Ö²»ºÃÊ - Web ¿ª·¢ / ASP

SQL code:

rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ