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 //
Ïà¹ØÎĵµ£º
SQLServerʱ¼äÈÕÆÚº¯ÊýÏê½â,SQLServer,ʱ¼äÈÕÆÚ,
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
ÀýÈ ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create&nb ......
SQLʹÓÃconvertÀ´È¡µÃdatetimeÈÕÆÚÊý¾Ý£¬ÒÔÏÂʵÀý°üº¬¸÷ÖÖÈÕÆÚ¸ñʽµÄת»»,
¿ÉÒÔͨ¹ý²éѯÓï¾ä¼°²éѯ½á¹ûÀ´ÏÔʾ²»Í¬µÄ¸ñʽ£¬Èç¹ûÊÇDate¸ñʽҲ¿ÉÒÔÓãº
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2 ......
´ÓA±íËæ»úÈ¡10Ìõ¼Ç¼,ÓÃSELECT TOP 10 * from ywle order by newid()
order by Ò»°ãÊǸù¾Ýijһ×Ö¶ÎÅÅÐò,newid()µÄ·µ»ØÖµ ÊÇuniqueidentifier ,order by newid()Ëæ»úÑ¡È¡¼Ç¼ÊÇÈçºÎ½øÐеÄ
newid()ÔÚɨÃèÿÌõ¼Ç¼µÄʱºò¶¼Éú³ÉÒ»¸öÖµ, ¶øÉú³ÉµÄÖµÊÇËæ»úµÄ, ûÓдóСд˳Ðò. ËùÒÔ×îÖÕ½á¹ûÔÙ°´Õâ¸öÅÅÐò, ÅÅÐòµÄ½á¹ûµ±È»¾ÍÊÇÎ ......
public static void main(String[] args) {
Session session = null;
Transaction tx = null;
List list = null;
&nb ......