sql ÎÊÌâ ¼± - .NET¼¼Êõ / ASP.NET
1. ʹÓÃÊý¾Ý¿â¹¤¾ßÅжϵ±Ç°Í¨µÀÊÇ·ñ´æÔÚÊý¾Ý¶ªÊ§ÏÖÏó
2. ij¸öͨµÀÓÐ16¸ö¸¨ÖúͨµÀ£¬Ê¹ÓÃÒ»Ìõ²éѯÓï¾ä²é³öÿ¸ö¸¨ÖúͨµÀµÄ¼Ç¼ÌõÊý
3. ʹÓÃÒ»ÌõÓï¾ä²é³öµ±Ç°ÔËÐÐͨµÀµÄÊý¾ÝÖÐ×î´óµÄµçѹֵ
4. ²é³öij¸öͨµÀµÄ×îºó10ÌõÊý¾Ý
5. ɾ³ý3¸öÔÂǰµÄÊý¾Ý
Çó¸÷λ´óϺ°ï°ïæÁË
¶¥ÁË¡¡
ѧϰ£¡£¡²»ºÃÒâ˼ Êý¾Ý¿â²»ÊǺܻᣡ
Â¥Ö÷Õâ¸öÎÊÌ⣬ÓÐÄÑ£¬ÎÒÒ²Óйý²î²»¶àµÄÎÊÌ⣬ ûÓнâ¾öµÄ£¬
°ï¶¥ÁË£¡£¡
Â¥Ö÷ûÓлØÅ¶£¬
°ï¶¥ÁË£¡£¡£¡£¡£¡
¶¥ÁË À´È˰¡¡¡
¸ã²»ÁË °ï¶¥
Â¥Ö÷ûÓлØÅ¶£¬¿ÉÄÜÒª½áÌùÁËŶ£¡£¡£¡£¡£¡£¡
²»¹ý²»ÊÇÒª°ï¶¥ÁË£¡£¡£¡£¡£¡
ÓÐÈËû°¡
µ½ÕâÈ¥ÕÒÕÒ ¡¡
http://topic.csdn.net/u/20100512/17/1a5fb051-6c38-495e-955d-6a040cf74662.html
ÕâÎÊÌâ À´È˰¡
Õâ¸öÎÊÌâÕ¦ ¾ÍûÈËÄØ£¿£¿£¿
ÎʵÃÌ«ÉîÁË£¬²»¶®£¬Ö»Äܰﶥ
×Ô¼º À´¶¥
¸úÄãÒ»ÑùÍ´¿àµÄÈË °ï¶¥£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
Í´¿à ×Ô¼ºÔÙÀ´ û·¨½áÌù°¡£¡
ͨµÀ¡£¡£¡£¡£
дsqlÕâô¶àÄ꣬
¾¹È»Ã»ÓÐÌý˵¹ý¡£¡£¡£
ºÇºÇ ͨµÀÆäʵ¾ÍÊÇÊý¾Ý¿âÀïÃæµÄÒ»¸ö×Ö¶Î
ÎÊÌâ²¹³ä£º
1. ʹÓÃÊý¾Ý¿â¹¤¾ßÅжϵ±Ç°Í¨µÀÊÇ·ñ´æÔÚÊý¾Ý¶ªÊ§ÏÖÏó
2. ij¸öͨµÀÓÐ16¸ö¸¨ÖúͨµÀ£¬Ê¹ÓÃÒ»Ìõ²éѯÓï¾ä²é³öÿ¸ö¸¨ÖúͨµÀµÄ¼Ç¼ÌõÊý
3. ʹÓÃÒ»ÌõÓï¾ä²é³öµ±Ç°ÔËÐÐͨµÀµÄÊý¾ÝÖÐ×î´óµÄµçѹֵ
4. ²é³öij¸öͨµÀµÄ×îºó10ÌõÊý¾Ý
5. ɾ³ý3¸öÔÂǰµÄÊý¾
Ïà¹ØÎÊ´ð£º
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵
3Q´ó¼Ò
htmlÒ³Ãæ.
Õâ¸ö,¼ÈÈ»Ö÷Ò ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......