SQL Server 2005Á¬½Ó´íÎó£¡ - .NET¼¼Êõ / ASP.NET
±¾ß.......
ÇëÎÊÊÇÕ¦»ØÊ°¡£¿
֮ǰÁ·µÄºÃºÃµÄ£¬Í»È»¾Í±ä³ÉÕâÁË£¿Çë¸ßÊÖÖ¸µãһϣ¡
֮ǰÁ¬µÄºÃºÃµÄ£¬Í»È»¾Í±ä³ÉÕâÁË£¿Çë¸ßÊÖÖ¸µãһϣ¡
Êǰ¡£¬Õ¦»ØÊ°¡
£¿£¿£¿£¿£¿£¿£¿
¿´²»¶®£¡£¡£¡£¡£¡£¡£¡£¡
ÀûÓà CSDNµÄÏà²á½øÐз¢Í¼Æ¬
²»ÒªÖ±½Ó·¢±ðµÄÍøÕ¾ÉϵÄͼƬ
°Ù¶È°ÑͼƬÆÁ±ÎÁË£¿£¿
֮ǰÁ¬µÄºÃºÃµÄ£¬Í»È»¾Í±ä³ÉÕâÁË£¿Çë¸ßÊÖÖ¸µãһϣ¡
Äã»ú×ÓÖØÆôÁËû? ÖØÆôÊÔÏÂ
ÎÒÊÔÊÔ
ÄãÊÇÔÚÄÄÀïÁ¬£¿ÊÇ·ñ¿ÉÒÔ´ò¿ªÆô¶¯SQL2005£¿
¼òµ¥ÓÐЧµÄ£ºÖØÐ°²×°ÏµÍ³»ò»Ö¸´ÏµÍ³±¸·Ý
Èç¹ûÄã»ú×ÓÖØÆôÁË »¹ÊÇÁ¬²»Éϵϰ ÄÇô¾Í½¨ÒéÄã֨װ
ÖØÆôÁËһϵçÄԾͿÉÒÔÁ¬ÉÏÈ¥ÁË£¬ÎªÉ¶£¿ËÄܸø½âÊÍһϣ¡
sql Óм¸¸ö½ø³ÌµÄ£¬ ¹À¼ÆÊÇ ¹Ø±ÕÁËÆäÖÐÒ»¸ö £¬ÄãÖØÆôÁË Ëû½ø³Ì ÓÖ¶¼¿ªÆôÁË
¶÷£¬Ð»Ð»£¡»¹ÓÐÒ»¸öÎÊÌâÏëÇë½Ìһϣ¬¾ÍÊÇÎÒÿ´ÎÁ¬½ÓÊý¾Ý¿âʱÓÐʱºòͬһ¸öÓû§Ãû£¨SQL Server 2005¾ÍÒ»¸öÓû§Ãû£©²ÉÓõÄÊÇSQL Éí·ÝÑéÖ¤£¬ÎªÉ¶ÓÐʱºòËüÁ¬½ÓµÄ²»ÊÇͬһ¸ö°æ±¾£¬ÏÔʾµÄÊý¾Ý¿âÃûºÍÊý¾Ý¿âÊýÁ¿Ò²²»Ò»Ñù¡£Çë´Í½Ì£¡
²»ÊÇͬһ¸ö°æ±¾£¿ ÄãÓÐºÜ¶à°æ±¾Ã´£¿
Á¬½Óºó<----->¹Ø±Õ
ÓÐʱºòÊÇ£ºSQL Server9.0.1399£¬ÓÐʱºòÊÇ£ºSQL Server 9.0.4053
End_rbody_65353654//-->
¸Ã»Ø¸´ÓÚ2010-05-12 17:19:32±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
swalp
(ÔçÉÏÆðÀ´Î¹¼¦)
µÈ¡¡¼¶£º
#24Â¥ µÃ·Ö£º10»Ø¸´ÓÚ£º2010-05-11 21:49:40
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£
js ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵
3Q´ó¼Ò
htmlÒ³Ãæ.
Õâ¸ö,¼ÈÈ»Ö÷Ò ......