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

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µ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

C#ºÍÊý¾Ý¿âSQL - MS-SQL Server / »ù´¡Àà

ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
  SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
  ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ