Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
{{----


Ïà¹ØÎÊ´ð£º

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔÏ°¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»ÁË°¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......

Çóһʱ¼ä±È½ÏµÄSQL Ö¸Áî - MS-SQL Server / »ù´¡Àà

±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......

ASPÒ³ÃæÎÞ·¨´ò¿ªÇóÖú£¡ - MS-SQL Server / »ù´¡Àà

¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......

C# SQL µÄUPDATETEXT ÎÊÌâ - .NET¼¼Êõ / C#

A±í ÓÐÁ½¸ö×ֶΠ
  id ΨһÊý×ÖÓò
  InfoTxt text ÀàÐÍ
 ÎÒÏÖÔÚÒª°Ñ id ²»ÊÇ14 µÄËùÓÐ InfoTxt×ֶΠÎı¾ºóÃæ ¶¼¼ÓÉÏ 'aaa' 
°´ÏÂÃæÖ´ÐÐÏÂÀ´ Ö»Óбí×îºóÒ»ÐмÓÉÏÁË 'aaa' ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ