SQL SERVERµÄÈÕÖ¾²éѯ¼°Undo
Çó½Ì¸÷λDBA´ó´ó£¬ÄãÃÇÈÕ³£¹¤×÷ÖÐÈçºÎ²é¿´ÊÂÎñÈÕÖ¾£¬ÔÚÓÐÈ˸ÉÁË»µÊºóÈçºÎ×·×Ùµ½ÔðÈÎÈË£¬ÈçºÎ»Ø¹öÕâЩÊÂÎñ£¿ ÎÒÔÚLumigent¹ÙÍøÉÏÒѾÕÒ²»µ½ÈκÎLog ExploreµÄÐÅÏ¢£¬´úÀíÉ̵ÄÍøÕ¾ÉÏÒ²Ö»ÓÐÕë¶Ôsql server 7.0 ºÍsql server 2000 sp2µÄ°æ±¾¡£ ÎÒÆ½Ê±ÓÃLog Explore for sql server 2005µÄÆÀ¹À°æ£¬²»ÊÇÄÇôºÃÓ㬶øÇÒËæ×ÅÊý¾Ý¿âµÄ°æ±¾²»¶ÏÉý¼¶£¬Ò²ÎÞ·¨ÔÙ¼ÌÐøÊ¹ÓÃÁË¡£ redgate ÓÐÒ»¿îSQL Log Rescue,²»ÖªµÀÄÄλ´ó´óÓùý£¬×îºÃÊÇÕýʽ°æ£¬Ì¸Ò»Ï¿ÉÓÃÐÔ£¬¶àл¡£ Çë¸÷λÓÐÐËȤµÄ¸½Ò»ÏÂÄúÏÖÔÚÊý¾Ý¿â°æ±¾¼°×·×Ù¹¤¾ß£¬´ó¼Ò½»Á÷ѧϰһÏ£¬Ð»Ð»¡«
ѧϰ,Õâ¶«Î÷²»¶® SQL 2005 RML·ÖÎö¹¤¾ß Êý¾Ý¿âÒýÇæÓÅ»¯¹ËÎÊ SQL SERVER PROFILER ÎÒÒ»°ãÊÇн¨±í¼Ç¼Óû§²Ù×÷ÈÕÖ¾ÒýÓà ÎÒÒ»°ãÊÇн¨±í¼Ç¼Óû§²Ù×÷ÈÕÖ¾ Õâ¸ö£¬ÄãÔõô¼Ç¼°¡£¬sql profileÒ»Ö±¿ª×Ű¡£¿ profiler + ÐÔÄܼàÊÓÆ÷ + ÁíÍ⽨Á¢Ò»¸öÓû§µÇ¼¼Ç¼±í Ò»°ã¶¼»¹¿ÉÒÔ¶ÔÓ¦¡£ ¿ØÖƺÃȨÏÞÒýÓà profiler + ÐÔÄܼàÊÓÆ÷ + ÁíÍ⽨Á¢Ò»¸öÓû§µÇ¼¼Ç¼±í Ò»°ã¶¼»¹¿ÉÒÔ¶ÔÓ¦¡£ ȨÏÞÊǿ϶¨Òª¿ØÖƵ쬵«ÊÇ×ܲ»ÄܱÜÃâÓÐÈËż¶ûԽȨ²Ù×÷£¬³öÁËÎÊÌâ¾ÍҪ׷¾¿ÔðÈÎÈ˰¡¡£ ÎÒÏÖÔÚÒѾ½¨Á¢ÁËÒ»Ì×Êý¾Ý¿âµÇ¼µÄ¼à¿Ø£¬·¢ÏÖÓÐÈËԽȨµÇ¼ÂíÉÏ×Ô¶¯·¢Óʼþ¾¯¸æËû¡£ µ«ÊdzöÁËÎÊÌâÒÔºóҪ׷²éÖ»ÄÜ·ÈÕÖ¾ÁË¡£ÒýÓà profiler + ÐÔÄܼàÊÓÆ÷ + ÁíÍ⽨Á¢Ò»¸öÓû§µÇ¼¼Ç¼±í Ò»°ã¶¼»¹¿ÉÒÔ¶ÔÓ¦¡£ ÕâЩÊDZØÒªµÄ£¬µ«ÊDz»Äܽâ¾ö×·¾¿ÔðÈεÄÎÊÌ⣬Óû§µ
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿ ......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True"); ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......