SQL SERVER 2005 °²×° - MS-SQL Server / »ù´¡Àà
ΪʲôÎÒ×°µÄSQL SERVER 2005ûÓÐʾÀýÊý¾Ý¿â£¿
ÊDz»Êǰ汾ÎÊÌ⣡£¡ XPÀïÃæ×îºÃ°²×°SQL SERVER 2005¿ª·¢°æ ΪʲôÎÒ×°µÄSQL SERVER 2005ûÓÐʾÀýÊý¾Ý¿â£¿ ÓÐЩ°æ±¾ÊÇûÓеÄ, ×Ô¼ºÈ¥ÍøÕ¾ÏÂÔØÊ¾ÀýÊý¾Ý¿â¾ÍÐÐÁË ÎÒÑ¡Ôñ°²×°Ê¾ÀýÊý¾Ý¿âÁË£¬¿ÉÊÇÁ¬½ÓµÄʱ¼ä³öÏÖÏÂÃæÌá ʾ Äã°²×°µÄʱºò ÊÇÑ¡ÔñĬÈÏʵÀýÃûÂð£¿Èç¹ûÊǵϰ·ÃÎÊʱ²»ÐèÒª \ʵÀýÃû£¬Ö»ÐèÓ÷þÎñÆ÷Ãû»òIP·ÃÎʾͿÉÒÔÁËÒýÓà Äã°²×°µÄʱºò ÊÇÑ¡ÔñĬÈÏʵÀýÃûÂð£¿Èç¹ûÊǵϰ·ÃÎÊʱ²»ÐèÒª \ʵÀýÃû£¬Ö»ÐèÓ÷þÎñÆ÷Ãû»òIP·ÃÎʾͿÉÒÔÁË ²»ÊÇÑ¡ÔñµÄĬÈÏʵÁС£×ÔÒÑдÁËһʵÀýÃû×ÖMYDB ytmytmллÁË ÍøÉÏÓа²×°ÊÓÆµ½Ì³ÌµÄ ×Ô¼ºÈ¥¿´¿´°É ²»¶®°¡¡£¡£¡£¡£ Òª²»»»¸ö°æ±¾£¡£¡£¡ÒýÓà ΪʲôÎÒ×°µÄSQL SERVER 2005ûÓÐʾÀýÊý¾Ý¿â£¿ ÄãÔÚ°²×°µÄʱºò,ҪѡÔñʾÀýÊý¾Ý¿â.¾ÍÊÇÓиöÏÂÀ¼ýÍ·,Ñ¡Ôñ°ÑËùÓй¦Äܰ²×°ÔÚ±¾»ú. ÍøÉÏÓн̳̿´¿´°É
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý select ²¿ÃÅ,ÐÕÃû from tb ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ XML code: <folder state="unchecked" label="È«²¿"> ¡¡¡¡ <folder state="unchecked&qu ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£© tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname ½á¹û£º µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ÓÐTABLEA ×Ö¶ÎΪ ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ ÏÖÏë°´ÕÕÎïÁϱàÂë²éѯ×î´óÈë¿âÈÕÆÚ Óï¾äÈçÏ£º SELECT ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ from TABLEA A WHERE Èë¿âÈÕÆÚ=(SELECT MAX(Èë¿âÈÕÆÚ ......