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
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......
/*
´¥·¢Æ÷»ñÈ¡SQLÓï¾äÔöÁ¿´«Êä
¹¦ÄÜ£º²¶×½Ð޸ıíµÄSQLÓï¾ä
ʹÓÃ˵Ã÷£º 1¡¢ÏÈн¨Ò»±íÊÖ¶¯Ð´ÈëÖ÷¼üÐÅÏ¢»òÕßΨһË÷Òý
Create table prmary_key
(tab_name varchar(255),
key_name varchar(255))
--´Ë±í½öÔÚ½¨Á¢´¥·¢Æ÷ʱʹÓ㬽¨ÍêËùÓд¥·¢Æ÷ºó ¼ÇµÃ ......
Introduction
Microsoft SQL Server 2008 R2 is the latest release of SQL Server. This article will introduce the top 10 features and benefits of SQL Server 2008 R2. The “R2” tag indicates this is an intermediate release of SQL Server and not a major revision. However, there are a number o ......
Ò»¡¢±¸·ÝÊý¾Ý¿â
1¡¢´ò¿ªSQLÆóÒµ¹ÜÀíÆ÷£¬ÔÚ¿ØÖÆÌ¨¸ùĿ¼ÖÐÒÀ´Îµã¿ªMicrosoft SQL Server
2¡¢SQL Server×é-->Ë«»÷´ò¿ªÄãµÄ·þÎñÆ÷-->Ë«»÷´ò¿ªÊý¾Ý¿âĿ¼
3¡¢Ñ¡ÔñÄãµÄÊý¾Ý¿âÃû³Æ£¨ÈçÂÛ̳Êý¾Ý¿âForum£©-->È»ºóµãÉÏÃæ²Ëµ¥ÖеŤ¾ß-->Ñ¡Ôñ±¸·ÝÊý¾Ý¿â
4¡¢±¸·ÝÑ¡ÏîÑ¡ÔñÍêÈ«±¸·Ý£¬Ä¿µÄÖеı¸·Ýµ½Èç¹ûÔÀ´Óз¾¶ºÍÃû³ ......
Ïò±íÖÐÌí¼ÓÒ»¸öмǼ£¬ÄãҪʹÓÃSQL INSERT Óï¾ä¡£
ÕâÀïÓÐÒ»¸öÈçºÎʹÓÃÕâÖÖÓï¾äµÄÀý×Ó£º
INSERT mytable (mycolumn) VALUES (‘some data’)
Õâ¸öÓï¾ä°Ñ×Ö·û´®’some data’²åÈë±ímytableµÄmycolumn×Ö¶ÎÖС£½«Òª±»²åÈëÊý¾ÝµÄ×ֶεÄÃû×ÖÔÚµÚÒ»¸öÀ¨ºÅÖÐÖ¸¶¨£¬Êµ¼ÊµÄÊý¾ÝÔÚµÚ¶þ¸öÀ¨ºÅÖиø³ö¡£
I ......