Îʼ¸¸öSQL Server2008µÄÎÊÌâ
1£¬ÕýʽÉÌÒµÓ¦Óò¿ÊðSQL Server2008+SP1(x86 32bit)ÏÖÔÚÓ¦¸ÃûÎÊÌâÁ˰ɣ¿ 2£¬Í¬ÑùµÄÓ²¼þÅäÖã¬sql2008ÊDz»ÊDZÈsql2005Õ¼×ÊÔ´£¿sql2008ÔËÐл᲻»á±Èsql2005Á÷³©£¿£¨vs2008¾Í±Èvs2005Á÷³©£© 3£¬sql2000µÄÊý¾Ý¿âÎļþ¿ÉÒÔÖ±½Ó¸½¼Óµ½sql2008ÉÏô£¿ ¶àл´ó¼Ò¡£
2008 還沒ÓÐÓÃ過 1²»ÖªµÀÈçºÎ»Ø´ð 2²»ÖªµÀÈçºÎ»Ø´ð 3¿ÉÒÔ sql2008ÓõıȽÏÉÙ£¿°ï¶¥£¡ÆÚ´ý¸ßÊÖ½â´ð ºÃÏñÓÐÈ˲âÊÔ¹ý£¬Õý³£µÄDMLÐÔÄÜÉÏûÓжà´óµÄ¸Ä½ø¡£ µ«ÊÇÄãÔËÓÃһЩÐµĹ¦ÄܺÍÓï·¨¿Ï¶¨¿ÉÒÔÌá¸ßÐÔÄܵġ£ ûÓÐÓùý................ ¼´ÊÇÕýʽÉÌÓã¬ÄǾÍÒªÂòÕý°æà¶£¿ ÕâЩÎÊÌâÍêÈ«¿ÉÒÔÓÉ΢Èí/»ò΢Èí´úÀí£¬À´¸ø³öרҵ»Ø´ð ¹µÐÖ£¬d°æµÄ¡£ ÕýʽÊÇÏà¶ÔÓÚ¸öÈËÊÔÓÃÀ´ËµµÄ¡£ 1.Èç¹ûÄãÒªÉÌÓ㬽¨ÒéMySql°É£¬±Ï¾¹Ãâ·Ñ£¬Èç¹ûÓõÁ°æMS-SQL£¬±»²éµ½¾ÍÍæÍêÁË¡£µ±È»Ð¡´òСÄÖ¾ÍÎÞËùνÁË¡£ 2.Äã¿ÉÒÔ¼Ù×°ÒªÂòSQL2008£¬ÏÖÔÚ´úÀíÒ²²»ºÃ»ì£¬ÄÇÖÖ¹ËÎÊ»á»Ø´ðµÄÏ൱×ÐϸµÄ¡£ÒýÓà 1.Èç¹ûÄãÒªÉÌÓ㬽¨ÒéMySql°É£¬±Ï¾¹Ãâ·Ñ£¬Èç¹ûÓõÁ°æMS-SQL£¬±»²éµ½¾ÍÍæÍêÁË¡£µ±È»Ð¡´òСÄÖ¾ÍÎÞËùνÁË¡£ 2.Äã¿ÉÒÔ¼Ù×°ÒªÂòSQL2008£¬ÏÖÔÚ´úÀíÒ²²»ºÃ»ì£¬ÄÇÖÖ¹ËÎÊ»á»Ø´ðµÄÏ൱×ÐϸµÄ¡£ ¼Ù×°ÒªÂòÒýÓà 1.Èç¹ûÄãÒªÉÌÓ㬽¨ÒéMySql°É£¬±Ï¾¹Ãâ·Ñ£¬Èç¹ûÓõÁ°æMS-SQL£¬±»²éµ½¾ÍÍæÍêÁË¡£µ±È»Ð¡´òСÄÖ¾ÍÎÞËùνÁË¡£ 2.Äã¿ÉÒÔ¼Ù×°ÒªÂòSQL2008£¬ÏÖÔÚ´úÀíÒ²²»ºÃ»ì£¬ÄÇÖÖ¹ËÎÊ»á»Ø´ðµÄÏ൱×ÐϸµÄ¡£ ¹µÐÖ£¬»¹ÊDz»ÌÖÂÛÊÇ·ñÕý°æµÄÕâ¸öÎÊÌâ°É¡£ ÎÒµÄÒâ˼ÊÇ£¬sql2008³öÁËsp1ÁË£¬Õýʽ²¿ÊðÏîÄ¿ÉÏÓ¦¸ÃûÎÊÌâÁ˰ɣ¿
Ïà¹ØÎÊ´ð£º
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡ Ëæ±ã¸ãÒ»D°æ°É£¬ ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓà 2000,2005¶¼ÕâÑù http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬ sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º ÈÕÆÚ 2010-1-25 14:45: ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬ »òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡ ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡 ֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡ °ïUP ²Î¿¼:http://hi.baidu.com/toiota ......