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

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

java windows7 MSSQL - Java / Java SE

ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïî¶¼english-unitedstates
Î¨Ò»Çø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......

oracle ÈçºÎµ÷ÓÃmssql´æ´¢¹ý³Ì - Oracle / ¸ß¼¶¼¼Êõ

oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......

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

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