ÉêÇëMSSQLÒÉÄÑÎÊÌâ°æ°æÖ÷,Ï£Íû´ó¼ÒÖ§³Ö!
»áÔ±ID£ºws_hgo ÉêÇë°æÃæ£ºSQL ServerÒÉÄÑÎÊÌâ ÉêÇë°æÖ÷ÀíÓÉ£ºÏ£ÍûÔÚCSDN¾¡¿ÉÄܵİïÖú´ó¼Ò,Ï£ÍûÄܹ»ºÍ´ó¼ÒÒ»ÆðÌá¸ßMSSQL¼¼Êõ ƽ¾ùÉÏÍøÊ±¼ä(Сʱ/Ìì)£º>12Сʱ ÊÇ·ñµ£Èιý±¾ÉçÇø»òÕ߯äËûÉçÇøÏà¹ØÖ°Îñ£ºÎÞ ¶ÔÉêÇë°æÃæÏÖ×´¼°ÄúµÄ¹ÜÀí¸Ä½øÒâ¼û: (1)ÕûÀí×Ô¼ºÈÕ³£Ñ§Ï°,¹¤×÷µÄ°¸ÀýºÍ´ó¼Ò·ÖÏí (2)¶¨ÆÚÕûÀíһЩ¾«»ªÌû×Ó (3)¶ÔÓÚÉæ¼°ÕþÖÎ,É«Çé,¹ã¸æµÄÌû×ÓÒ»ÂÉɾ³ý ¶ÔÂÛ̳µÄ½¨Ò飺 (1)¼õÉÙÍøÕ¾BUG (2)Ìá¸ß·ÃÎÊËÙ¶È ¼¼ÊõÐËȤÒÔ¼°×¨³¤£ºMSSQL,C#,JS,AJAX,ASP.NET ¸½ÉÏ12¸öÔÂÄÚ´ðÌâÁ´½Ó£º http://topic.csdn.net/u/20090313/10/30cd0407-3d5b-4fee-bb79-3897c137cba6.html http://topic.csdn.net/u/20090317/16/c7f5c2e3-293d-4d67-85be-0a4a17d52855.html http://topic.csdn.net/u/20090510/13/e48161d0-f100-4151-8cfc-0895869706bb.html?seed=1668282403 http://topic.csdn.net/u/20090428/14/747B847E-1D34-42B8-B539-4CAC7E54F609.html http://topic.csdn.net/u/20090417/10/C6AA1259-ADB2-48B5-B0A3-ED759202BDEA.html http://topic.csdn.net/u/20090409/09/603EB2BE-35FC-4B85-9C3F-7FA0DFF03DCA.html http://topic.csdn.net/u/20090407/00/0DAF8F81-0F24-49B5-BD90-8598B1A21441.html http://topic.csdn.net/u/20090421/15/C0953F72-5D61-43DF-8122-763C7CF9819F.html http://topic.csdn.net/u/20090421/16/C420DEE1-21E8-4061-BDCA-BF90EF4A4490.html
sf sf 00 ...ÒýÓÃ sf <
Ïà¹ØÎÊ´ð£º
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£ Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïî¶¼english-unitedstates Î¨Ò»Çø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬ exec sp_helpsor ......
×î½ü¹«Ë¾»»Êý¾Ý¿â£¬mssql »» mysql ¡£´ó¼ÒÓÐʲôºÃµÄ·½·¨°¡£¡ ²»ÓÃphpת»»£¬´æÔÚÊý¾ÝÄ£Ð͵ÄÎÊÌâ¡£±¾È˺ÜÏëÓÃphp£¬¿ÉÊÇmssqlÀ©Õ¹Ôõô¶¼¼ÓÔØ²»ÉÏ£¬¸ãÁËÒ»Ììû¸ãÃ÷°×£¡»·¾³ÊÇ£ºapache2.2.4£¬php5.3.2£¨°²×°³ ......
UPDATE a SET a.KeyNum=(SELECT COUNT(b.CI_ID) from myTab.dbo.CI_SinKey as b where CONTAINS(b.SearchKey,a.KeyName) ) from myKey.dbo.SearchKey as a where KeyNum=0 Õâ¸öÊÇ´íÎóµÄÓï¾ä£¬ÏàÐÅ´ó¼Ò¿ÉÒÔ¿´¶® ......
a±íuid¡¢fidºÍb±íÖеÄid¹ØÁª£¬ ÈçºÎ²éѯa.uidºÍa.fid¶ÔÓ¦b±íÖеÄÏàÓ¦×ֶΡ£ SQL code: select a.uid,a.fid,b.* from a,b where a.uid=b.id and a.fid=b.id ÄãÊÇ˵b.idÊÇÓÉa.uid ºÍa.fid×é³ÉµÄ£¿ ÒªÊÇµÄ ......