SQL ServerÈ«ÎÄË÷ÒýµÄ¸öÈË×ܽá(ÏÂ) ¹ØÓÚÖÐÎÄ·Ö´Ê
SQL ServerÈ«ÎÄË÷ÒýµÄ¸öÈË×ܽá(ÏÂ)-¹ØÓÚÖÐÎÄ·Ö´Ê
(2005-11-14 04:32:01)
תÔØ
·ÖÀࣺÉî¶ÈÑо¿
ÔÚʹÓÃSQL SearchµÄ¹ý³ÌÖУ¬»¹·¢ÏÖÁËÒ»¸öÎÊÌ⣺Ëü¶ÔÖÐÎÄ£¬ÊÇ°´×ִַʵģ¬ÏÂÃæÎÒ½âÊÍһϣº
±ÈÈç¶Ô'²©¿ÍÌóÉÔ±ºÜ¶àÊÇMVP'Õâ¾ä»°£¬¼ÙÈçÒ»¸ö¸öµÄ×ÖµÄ×÷Ë÷Òý£¬»á±ÈʹÓÃ'²©¿ÍÌÃ','³ÉÔ±',MVP'¼¸¸ö´Ê×÷Ë÷ÒýÉú³ÉµÄË÷Òý´óºÜ¶à£¬ÕâÑù²»½öÀ˷ѿռ䣬ҲӰÏìË÷ÒýµÄЧÂʺÍ׼ȷ¶È¡£¼ÙÈçÓ¢ÎÄÊÇ°´ÕÕ×Öĸ¶ø²»Êǵ¥´Ê×÷Ë÷Òý£¬¹À¼ÆÊÀ½çÉÏÈç½ñ¾ÍûÓÐÈ«ÎÄË÷Òý£¬Ò²Ã»ÓÐgoogleÁË¡£
µ«ÊÇÖÐÎÄÔÚ·Ö´ÊÉÏ£¬Ïà±ÈÓ¢ÎÄÓÐÌìÈ»µÄÆÁÕÏ£¬Ó¢Îĵĵ¥´ÊÖ®¼äÓмä¸ô£¬µ«ÊÇÖÐÎIJ»ÊÇ£¬±ØÐëʹÓüÆËã»úµÄÈ˹¤ÖÇÄܰѾä×Ó·Ö³ÉÒ»¸ö¸öµÄ´Ê£¬ÓÐЩʱºò£¬¸ù¾Ý¾ä×Ó±¾Éí»¹²»¹»£¬»¹±ØÐë¸ù¾ÝÉÏÏÂÎÄ£¬»òÕßһЩÈÕ³£ÖªÊ¶²ÅÄÜÅжϡ£±ÈÈç ƹÅÒÇòÅÄ/Âô/ÍêÁË ºÍ ƹÅÒÇò/ÅÄÂô/ÍêÁË £¬µçÄÔÕ¦ÄÜÖªµÀÊÇÄĸöÒâ˼²¢ÕýÈ··Ö´ÊÄØ£¡
¸ù¾ÝʹÓõĽá¹û£¬SQL Search¶ÔÖÐÎÄʹÓõÄÓ¦¸ÃÊÇ°´×Ö·Ö´Ê(¿ÉÄÜÊÇÒòΪÔÀ´ÊÇÓ¢ÎÄÒýÇæµÄÔµ¹Ê)£¬±È·½ËµÄãÒª²é'Âí¿Ë'£¬Ëü»á°Ñ'Âí¿Ë˼'Ò²¸øÄãµ¹ÌÚ³öÀ´¡£
ÎÒµÄÒ»¸ö123MµÄÊý¾Ý¿â£¬È«ÎÄË÷ÒýÓÐ55M£¬Ã¿´ÎÈ«ÎIJéѯ¶¼±È½ÏÂý(µ±È»»úÆ÷Ò²ºÜ´Î)¡£
--------------------------------------------------------------------------------------------------
¹ØÓÚ°´×Ö·Ö´Ê£º
Ó¦¸Ã»¹ÊÇâùºì¹«×ÓµÄ˵·¨±È½ÏÍ×µ±£¬´ó¼Ò¿´¿´Õâ¸ö¾ä×Ó£º
²Ù×÷ϵͳÄÜ·ñÓûãÆÓïÑÔ¸ÄдÏÞÖÆËü¶Ôÿ¸ö¶Ë¿ÚµÄʹÓÃÂÊ
ΪÁËÑéÖ¤·Ö´Ê£¬¹ÊÒâʹÓôíÎóµÄ·Ö´Ê£¬¼ÙÈ綼¿ÉÒÔË÷Òý³ö¸Ã¾ä×Ó£¬¾Í˵Ã÷ÊÇ°´×ִַʵġ£±ÈÈçʹÓà 'Óûã' ?²éѯ£¬Ò²¿ÉÒÔ²é³ö¾ä×Ó£¬ËùÒԵóöÁËSQLServer°´×ִַʵĽáÂÛ£¬ÎÒûÓнøÒ»²½¼ì²é£¬µ«ÊÇÏÖÔÚ·¢ÏÖʹÓÃ'дÏÞ'£¬Ê¹ÓÃ'ͳÄÜ'¾ÍÎÞ·¨²é³öÀ´ÁË£¬Ö¤Ã÷SQLServerÖл¹ÊÇÓмòµ¥·Ö´ÊµÄ£¬Ö»ÊǷִʽá¹û²»ÀíÏë¡£
´ËÍ⣬SQLServer»¹¿ÉÒÔʹÓõÚÈý·½µÄ²úÆ·ÔöÇ¿·Ö´ÊµÄÄÜÁ¦¡£
--------------------------------------------------------------------------------------------------
¼ÙÈç¶Ô·Ö´ÊÓÐÐËȤµÄÅóÓÑ£¬ÕâÀïÓÐһЩ´úÂë¿ÉÒÔ¿´£¬Ê¹Ó÷¢ÏÖ·Ö´ÊÕýÈ·ÂÊ»¹ÊǺܸߵģ¬²»¹ýҪע²á²Å¿ÉÒԵõ½£ºhttp://www.nlp.org.cn/project/project.php?proj_id=6
·¢±íÓÚ 2004Äê3ÔÂ19ÈÕ 11:22
²»¹âÓУ¬ÎÒÃÇ»¹¿ÉÒÔÔÚ³ÌÐòÖÐʹÓ㨲»¹ýÎҼDz»Ì«Çå³þSQL Server FulltextÓõÄË÷ÒýÊDz»ÊǺÍIndex ServerÒ»ÑùÁË£©£º
using System;
using System.Runtime.InteropServices;
namespace FullTextAPI
{
[Flags]
public enum WordBreakType //
Ïà¹ØÎĵµ£º
Load the SQL Server 2005 Driver for JDBC before you load the SQL Server 2000 Driver for JDBC. To do this, use the DriverManager class as in the following code example.
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); // 2005 version
Class.forName("com.microsoft.jdbc.sqlserver.SQLSe ......
SQLÃæÊÔÌ⣨1£©
create table testtable1
(
id int IDENTITY,
department varchar(12)
)
select * from testtable1
insert into testtable1 values('Éè¼Æ')
insert into testtable1 values('Êг¡')
insert into testtable1 values('ÊÛºó')
/*
½á¹û
id department
1 Éè¼Æ
2 Êг¡
3& ......
´ÓA±íËæ»úÈ¡10Ìõ¼Ç¼,ÓÃSELECT TOP 10 * from ywle order by newid()
order by Ò»°ãÊǸù¾Ýijһ×Ö¶ÎÅÅÐò,newid()µÄ·µ»ØÖµ ÊÇuniqueidentifier ,order by newid()Ëæ»úÑ¡È¡¼Ç¼ÊÇÈçºÎ½øÐеÄ
newid()ÔÚɨÃèÿÌõ¼Ç¼µÄʱºò¶¼Éú³ÉÒ»¸öÖµ, ¶øÉú³ÉµÄÖµÊÇËæ»úµÄ, ûÓдóСд˳Ðò. ËùÒÔ×îÖÕ½á¹ûÔÙ°´Õâ¸öÅÅÐò, ÅÅÐòµÄ½á¹ûµ±È»¾ÍÊÇÎ ......
¾¯±¨¹ÜÀí
×÷ÒµÖ´ÐÐʱ£¬SQL Server´íÎóÏûÏ¢µÄÐÅÏ¢´æ·ÅÔÚWindowsÊÂÎñÈÕÖ¾ÖС£SQL Server´úÀí¶ÁÈ¡Õâ¸öÈÕÖ¾£¬²¢±È½Ï´æ´¢µÄÏûÏ¢ÓëΪϵͳ¶¨ÒåµÄ¾¯±¨£¬Èç¹ûÆ¥Å䣬SQL Server´úÀí¼¤»î¸Ã¾¯±¨£¬ËùÒÔ£¬¾¯±¨¿ÉÒÔÓÃÓÚÏìӦDZÔÚµÄÎÊÌâ(ÈçÌîÂúÊÂÎñÈÕÖ¾)¡£µ±¾¯±¨±»´¥·¢Ê±£¬Í¨¹ýµç×ÓÓʼþ»òÕßÑ°ºô֪ͨ²Ù×÷Ô±£¬´Ó¶øÈòÙ×÷Ô±Á˽âϵͳÖз¢ÉúÁËʲà ......
win7 Ï ÅäÖà SQL Server 2005 ÔÊÐíÔ¶³Ì·ÃÎÊ
2010Äê2ÔÂ2ÈÕ bibiQ
±¾À´Ò»Ö±²»Ô¸ÒâÅäÖÃÔ¶³Ì·ÃÎÊSQL server£¬µ«½ñÌìÒ»ºÝÐÄ°ÑËüÅäºÃÁË¡£
²Î¿¼ÁËÍøÉϵÄÌû×Óhttp://www.cnblogs.com/sukiwqy/archive/2009/11/11/1601381.html
step1£º ÅäÖÃSQL Server ÍâΧӦÓÃÅäÖÃÆ÷£¨Îª SQL Server 2005 ÆôÓÃÔ¶³ÌÁ¬½Ó¡¢ÆôÓà SQL Server Brow ......