MSSQL¿ç¿â¸üÐÂÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ
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 Õâ¸öÊÇ´íÎóµÄÓï¾ä£¬ÏàÐÅ´ó¼Ò¿ÉÒÔ¿´¶®ÎÒµÄÒµÎñÐèÇó£¬ÎÒÔÙÃèÊöһϠÁ½¸ö¿â£ºmyKey myTab ¶ÔÓ¦±í£ºSearchKey CI_SinKey SearchKey ÕâÀï³öÏÖ×ֶΣºKeyNum(¹Ø¼ü´ÊÆ¥ÅäÊý¾Ý×ÜÁ¿) KeyName£¨¹Ø¼ü´Ê£© CI_SinKey ÕâÀï³öÏÖ×ֶΣºCI_ID£¨Ä¬ÈÏID£© SearchKey£¨¹Ø¼ü´Ê£© ÒµÎñÐèÇ󣺸üРmyKey ¿â SearchKey ±í KeyNumΪOµÄ¼Ç¼ µÄ KeyNum(¹Ø¼ü´ÊÆ¥ÅäÊý¾Ý×ÜÁ¿) ʹ KeyNum=SELECT COUNT(b.CI_ID) from myTab.dbo.CI_SinKey as b where CONTAINS(b.SearchKey,a.KeyName)) ÉÏÃæÓï¾äÌáʾCONTAINS(b.SearchKey,a.KeyName))ÖÐa.KeyName²¿·Ö³ö´í ÔÚÏߵȷ···¼±¼±¼±~
[·þÎñÆ÷].myTab.dbo.CI_SinKey дÍêÕû¿´¿´¡£ ÒýÓà [·þÎñÆ÷].myTab.dbo.CI_SinKey дÍêÕû¿´¿´¡£ ²»ÐÐŶ·· a.KeyName µÄ½á¹û¼¯²»·ûºÏcontainsµÄ¸ñʽҪÇó¡£ a.KeyName ÊÇ×Ö·ûÐ͵İɣ¿¡· SQL code: USE AdventureWorks; GO SELECT Name from Production.Product WHERE CONTAINS(Name, ' "Mountain" OR "Road" ') GO ²Î¿¼¡£ ¾ßÌå¸ü¶àµÈ´ý¸ßÊÖ... SQL code {{----
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬ »òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡ ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡 ֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡ °ïUP ²Î¿¼:http://hi.baidu.com/toiota ......
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44 Í ......