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

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

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·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ