Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 //


Ïà¹ØÎĵµ£º

sqlÈÕÆÚº¯Êý

SQLServerʱ¼äÈÕÆÚº¯ÊýÏê½â,SQLServer,ʱ¼äÈÕÆÚ,
1.      µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
        select getdate()
2. dateadd      ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
       ÀýÈ ......

³£Óþ­µäSQLÓï¾ä¼¯ºÏ(ÊÕ¼¯)

ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ 
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE) 
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert) 
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create&nb ......

SQL ServerÖÐDateTime¸ñʽת»»

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 ......

Sql NewId() Ëæ»úÊý £¨×ª£©


´ÓA±íËæ»úÈ¡10Ìõ¼Ç¼,ÓÃSELECT TOP 10 * from ywle order by newid()
order by Ò»°ãÊǸù¾Ýijһ×Ö¶ÎÅÅÐò,newid()µÄ·µ»ØÖµ ÊÇuniqueidentifier ,order by newid()Ëæ»úÑ¡È¡¼Ç¼ÊÇÈçºÎ½øÐеÄ
newid()ÔÚɨÃèÿÌõ¼Ç¼µÄʱºò¶¼Éú³ÉÒ»¸öÖµ, ¶øÉú³ÉµÄÖµÊÇËæ»úµÄ, ûÓдóСд˳Ðò. ËùÒÔ×îÖÕ½á¹ûÔÙ°´Õâ¸öÅÅÐò, ÅÅÐòµÄ½á¹ûµ±È»¾ÍÊÇÎ ......

hibernate ¶àÌõ¼þ×éºÏ²éѯ Ö® sql Æ´½Ó

  public static void main(String[] args) {
      
       Session session = null;
       Transaction tx = null;
       List list = null;
     &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ