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

SQL ServerÊÂÎñÈÕÖ¾½ÒÃØ

ÊÂÎñÈÕÖ¾ÀïÃ擲ؔןܶàÓÐÓõÄÐÅÏ¢¡£ËäÈ»SQL Server±¾Éí²¢Ã»ÓÐÌṩ·ÖÎö¹¤¾ß£¬µ«ÊÇÎÒÃÇ¿ÉÒÔʹÓõÚÈý·½¹¤¾ßÀ´Ò»Ì½¾¿¾¹¡£
Red GateÈí¼þÌṩÁËÒ»¿î½Ð×öSQL Log RescueµÄÃâ·Ñ¹¤¾ß£¬µ«ÊÇÖ»Ö§³ÖSQL Server 2000¡£ApexSQLºÍLumigent¹«Ë¾ÌṩµÄÁ½¿îÈí¼þ·Ö±ð½Ð×öApexSQL LogºÍLog Explorer£¬ËüÃÇÖ§³ÖSQL Server7¡¢2000ºÍ2005£¬Í¬Ê±Ìṩ¸ü¶àµÄ¹¦ÄÜ¡£
ÏÂÃæÕâ¸öÀý×ÓÏÔʾÁËһЩÄãʹÓÃApexSQL Log´ÓÊÂÎñÈÕÖ¾ÖгéÈ¡³öÀ´µÄÐÅÏ¢
(µã»÷²é¿´ÍêÕûͼƬ)
 
ÒÔÉÏÐÅÏ¢¿ÉÒÔ°ïÖúÄ㣺
¾«È·ÕÒ³öË­(ÈÕÖ¾ÖмǼÁËÓû§Ãû)ÔÚʲôʱ¼ä(ÈÕ־ʱ¼ä)ÔÚʲôµØ·½(¼ÙÈçÕýÔÚʹÓÃApexSQL Log)ʹÓÃÁËʲôӦÓóÌÐò(¼ÙÈçÒ²ÊÇʹÓÃApexSQL Log)×öÁËʲô(ÈÕÖ¾ÖмǼÁ˱ä¸ü)
³·ÏûÊý¾Ý¸ü¸Ä¡£ÒòΪÿ¸öÈÕÖ¾¶¼¼Ç¼ÁËÿ´ÎÊý¾Ý²Ù×÷Ç°ºóµÄÖµ¡£
±¾ÎÄ·­Òë×Ôsqlbackuprestore£¬¸ü¶à¾«²ÊÄÚÈÝÇëä¯ÀÀhttp://www.sqlbackuprestore.com


Ïà¹ØÎĵµ£º

SQL·ÖÒ³·½·¨

±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)
Ò²¿ÉÒÔʹÓÃÁªºÏÖ÷¼ü id+id2+id3+……
 
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
Óï¾äÐÎʽ£º  
SELECT TOP 10 *
from TestTable
WHERE (ID NOT IN
          (SELECT TOP 20 id
&nb ......

SQL ServerÖд洢¹ý³ÌÓ뺯ÊýµÄÇø±ð

SQL ServerÓû§×Ô¶¨Ò庯ÊýºÍ´æ´¢¹ý³ÌÓÐÀàËƵŦÄÜ£¬¶¼¿ÉÒÔ´´½¨À¦°óSQLÓï¾ä£¬´æ´¢ÔÚserverÖй©ÒÔºóʹÓá£ÕâÑùÄܹ»¼«´óµØÌá¸ß¹¤×÷ЧÂÊ£¬Í¨¹ýÒÔϵĸ÷ÖÖ×ö·¨¿ÉÒÔ¼õÉÙ±à³ÌËùÐèµÄʱ¼ä£º
¡¡¡¡ 1 Öظ´Ê¹Óñà³Ì´úÂ룬¼õÉÙ±à³Ì¿ª·¢Ê±¼ä¡£
¡¡¡¡ 2 Òþ²ØSQLϸ½Ú£¬°ÑSQL·±ËöµÄ¹¤×÷Áô¸øÊý¾Ý¿â¿ª·¢ÈËÔ±£¬¶ø³ÌÐò¿ª·¢Ô±Ôò¼¯Öд¦Àí¸ß¼¶±à³Ì ......

SQL Server±¸·ÝÊÂÎñÈÕÖ¾½áβ(Tail)

ÊÂÎñÈÕÖ¾½áβ¾­³£Ìá½»Êý¾Ý¿âδ±¸·ÝµÄÊÂÎñÈÕÖ¾ÄÚÈÝ¡£»ù±¾ÉÏ£¬Ã¿Ò»´ÎÄãÖ´ÐÐÊÂÎñÈÕÖ¾±¸·Ýʱ£¬Ä㶼ÔÚÖ´ÐÐÊÂÎñÈÕÖ¾½áβµÄ±¸·Ý¡£
ÄÇΪʲô»áÕâôÉè¼ÆÄØ£¿ÒòΪҲÐíÓÉÓÚ½éÖʵÄË𻵣¬µ±Êý¾Ý¿âÒѾ­²»ÔÙ¿ÉÓÃʱ£¬Âé·³¾ÍÀ´ÁË¡£Èç¹ûÏÂÒ»¸öÂß¼­²½ÖèÕýºÃ¾ÍÊÇÒª±¸·Ýµ±Ç°ÊÂÎñÈÕÖ¾µÄ»°£¬¿ÉÒÔÓ¦ÓÃÕâ¸ö±¸·ÝÀ´Ê¹Êý¾Ý¿â´¦Óڵȴý(Standby)״̬¡£ÄãÉ ......

SQL Server ÖеIJéѯ֪ͨ (ADO.NET)

²éѯ֪ͨÊÇÔÚ Microsoft SQL Server 2005 ÖÐÒÔ¼° ADO.NET 2.0 µÄ System.Data.SqlClient ÃüÃû¿Õ¼äÖÐÒýÈëµÄ¡£²éѯ֪ͨ½¨Á¢ÔÚ Service Broker »ù´¡½á¹¹µÄ»ù´¡ÉÏ£¬Ê¹Ó¦ÓóÌÐò¿ÉÒÔÔÚÊý¾Ý¸ü¸ÄʱÊÕµ½Í¨Öª¡£Èç¹ûÓ¦ÓóÌÐòÌṩÊý¾Ý¿âÖÐÐÅÏ¢µÄ»º´æ£¨ÀýÈç Web Ó¦ÓóÌÐò£©£¬ÐèÒªÔÚÔ´Êý¾Ý¸ü¸Äʱ½ÓÊÕ֪ͨ£¬´Ë¹¦ÄÜÌرðÓÐÓá£
ͨ¹ýÈýÖÖ·½Ê½ ......

PL/SQL 001

ÔÚ Oracle 10g  ÖР
¿ÉÒÔͨ¹ý http://localhost:5560/isqlplus ·ÃÎÊ isqlplus 
ÔÚ isqlplus ÖÐ ¿ÉÒÔÖ´ÐÐ plsql
set serveroutput on size 100000   // ´ò¿ª ·þÎñÆ÷µÄÊä³ö  on ºóÃæÊÇ »º´æµÄ´óС ·¶Î§ÊÇ  (2000 ÖÁ 1000000)
begin
   dbms_output.put_line('hel ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ