Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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
{{----


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

phpÁ¬½ÓMSSQL Á¬²»ÉÏ - PHP / »ù´¡±à³Ì

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
Í ......

¹ØÓÚSQLÓï¾äORµÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ