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

MSSQLµÄIndexÒ²ÒªÓÅ»¯¡£

ÔÚ´¦ÀíϵͳÓÅ»¯µÄʱºò£¬·¢ÏÖindexʹÓò»µ±µÄ»°£¬ÏµÍ³µÄÐÔÄܲ»Äܺܺ÷¢»Ó¡£
È磺½ñÌìµÄ·¢ÏÖµÄÒ»¸ösqlÓï¾ä£¬¾­¹ý·ÖÎö£¬Ê¹ÓÃÁË2¸öindex¡£µ«ÊÇ2¸öindex·µ»ØµÄ¼Ç¼ÔÚ»¥ÏàÆ¥Åä¹ý³ÌÖкÄʱ×î¶à¡£ËùÒÔ£¬¼´Ê¹SQLÓï¾äʹÓÃindex£¬Ò²²»´ú±íÕâ¸öÓï¾äÔÚÐÔÄÜÉÏÊǺܺõġ£


Ïà¹ØÎĵµ£º

MSSQLÖмì²éËùʹÓõÄÓï¾äÊÇ·ñ±ê×¼

 ¼ì²éËùʹÓõÄÓï¾äÊÇ·ñ±ê×¼
 /*
     ±ê×¼SQLºÍT-SQLÖ®¼äÓкܶàÇø±ð——Ì«¶àÁË£¬ÕâÀï¾Í²»ËµÁË¡£»¹ÓУ¬Èç¹ûÄãÔÚSQL ServerÉϹ¤×÷£¬
 ÄÇôʹÓÃÕâЩ˽ÓеÄÀ©Õ¹ÊÇÓкô¦µÄ¡£ÓÉÓÚÐí¶àSQL ServerµÄÌØÐԵı¾ÖÊ£¬Ä㲻ʹÓ÷DZê×¼µÄÃüÁîµÄ»°£¬
 ½«»áÓкܶàÇ¿´óµÄ¹¦ÄÜÎÞ·¨ÊµÏÖ¡ ......

MSSQL¾­µäÓï¾ä

MSSQL¾­µäÓï¾ä
1.°´ÐÕÊϱʻ­ÅÅÐò:Select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
2.Êý¾Ý¿â¼ÓÃÜ:select encrypt('ԭʼÃÜÂë')
select pwdencrypt('ԭʼÃÜÂë')
select pwdcompare('ԭʼÃÜÂë','¼ÓÃܺóÃÜÂë') = 1--Ïàͬ£»·ñÔò²»Ïàͬ encrypt('ԭʼÃÜÂë')
select pwdencrypt('ԭʼÃÜÂë' ......

ͨ¹ýMSSQL Server Agent Ö´ÐÐDTS °üµÄÎÊÌâ

ÖÆ×÷ÁËÒ»¸öDTS°ü£¬Äܹ»¿ª·¢»·¾³»òÕßÃüÁîÐÐÏÂÕýÈ·µÄÖ´ÐУ¬µ«ÔÚͨ¹ýAgent À´Ö´ÐеÄʱºò×ÜÊDZ¨´í£º
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step DTSRun OnError: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step, Error = ......

MSsqlÿÌì×Ô¶¯±¸·Ý×Ô¶¯Çå³ýÈÕÖ¾µÄ²Ù×÷·½·¨

1¡¢Ã¿ÈÕ×Ô¶¯±¸·Ý
¡¡¡¡´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬½øÈ듹ÜÀí”-“Êý¾Ý¿âά»¤¼Æ»®”£¬ÔÚÓҲര¿Úµã»÷ÓÒ¼ü£¬Ñ¡Ôñ“н¨Î¬»¤¼Æ»®”£¬Æô¶¯“Êý¾Ý¿âά»¤¼Æ»®Ïòµ¼”;µã»÷“ÏÂÒ»²½” Ñ¡ÔñÐèҪά»¤µÄÊý¾Ý¿â£¬Î¬»¤ÌØÐÔÊý¾Ý¿âʱ£¬Ñ¡Ôñ×îºóÒ»¸öµ¥Ñ¡¿ò²¢¹´Ñ¡ÐèҪά»¤µÄÊý¾Ý¿âÃû³Æ;“ÏÂÒ» ......

ͨ¹ýÈÕÖ¾»Ö¸´MSSQLÊý¾ÝÀý×Ó

Õâ¶Îʱ¼ä¿´Á˹ØÓÚÔÚSQL server ÖÐͨ¹ýÈÕÖ¾ºÍʱ¼äµãÀ´»Ö¸´Êý¾Ý¡£Ò²¿´ÁËһЩÍøÉϵÄÀý×Ó£¬¿´ÈçºÎͨ¹ýÈÕÖ¾À´»Ö¸´Êý¾Ý¡£ 
    Ç°ÌáÌõ¼þ£º
        Êý¾Ý¿âµÄ¹ÊÕϻָ´¸ÄΪ·Ç¼òµ¥Ä£Ê½£¬È¥µô×Ô¶¯¹Ø±ÕºÍ×Ô¶¯ÊÕËõÁ½¸öÑ¡Ïî     
   &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ