sqlserver Êý¾Ý¿â»Ö¸´µÄÎÊÌâ
ÏÖÔÚÓÉÓÚÐÂÊÖÎó²Ù×÷£¬ÏÖÔÚֻʣÏÂÈÕÖ¾ÎļþÁË£¬ÇëÎʸßÊÖÄܲ»Äָܻ´£¬Ð»Ð»£¡
SQL code:
ÊDz»ÊÇÍêÕû»Ö¸´Ä£Ê½??
ʹÓÃLog Explorer²é¿´ºÍ»Ö¸´Êý¾Ý
Log Explorer 4.1.¿ÉÓÃÓÚSQL Server2005µÄÈÕÖ¾²é¿´¹¤¾ß
ÏÂÔØµØÖ·:
http://download.csdn.net/source/620271
ʹÓ÷½·¨:
´ò¿ªLog Explorer -> Attach Log File -> Ñ¡ÔñSQL Server·þÎñÆ÷ºÍµÇ½·½Ê½ -> Connect ->
ÔÚDatabase NameÖÐÑ¡ÔñÊý¾Ý¿â -> Attach-> ×óÃæ¶Ô»°¿òÖÐBrowse-> View Log-> ¾Í¿ÉÒÔ¿´µ½log¼Ç¼ÁË
Ïë»Ö¸´µÄ»°: ÓÒ¼üLog¼Ç¼ Undo Transation-> Ñ¡Ôñ±£´æÎļþÃûºÍ·¾¶-> È»ºó´ò¿ª¸ÃÎļþµ½²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐ
T-sql´úÂë¾Í¿ÉÒÔÁË
ÀýÈç Èç¹ûLogÊÇdelete table where ...µÄ»°,Éú³ÉµÄÎļþ´úÂë¾ÍÊÇinsert table ....
È»ºó½«´Ëinsert tableµÄ´úÂë·Åµ½²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐ.¾Í¿ÉÒÔ»Ö¸´Êý¾Ý.
----------------------------------------------------------------------
--ÈçºÎ»Ö¸´±»delete/updateµÄÊý¾Ý
----------------------------------------------------------------------
1¡¡Á¬½Óµ½±»É¾³ýÊý¾Ý¿âµÄDb
´ò¿ªlog explorer Ñ¡Ôñ "file"->"attach log file"->Ñ¡Ôñ·þÎñÆ÷ºÍµÇ½·½Ê½->"connect"->Ñ¡Ôñ"Êý¾Ý¿â"->"attach"
2 ²é¿´ÈÕÖ¾
ÔÚ×óÃæ²Ù×÷ÏîÄ¿µÄ¶Ô»°¿òÖÐÑ¡Ôñ"browse"ÏîÄ¿->"view log"->¾Í¿ÉÒÔ¿´µ½µ±Ç°µÄLog¼Ç¼ÁË
3 »Ö¸´Êý¾Ý
ÓÒ¼üijһÌõlog¼Ç¼,Ñ¡Ôñ"undo transation"->"Ñ¡Ôñ±£´æÎļþÃûºÍ·¾¶"->È»ºó´ò¿ª¸ÃÎļþµ½²éѯ·ÖÎ
Ïà¹ØÎÊ´ð£º
ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç
select * from table where contect('sdfsd',sdf) and ......
Çë½Ì¸÷λ£º
ÔÚ³¬ÊеÄÊÕÒøÏµÍ³ÖУ¬Èç¹ûÓÐ20¶à¸ö¿Í»§¶Ë£¬ÓпÉÄÜͬʱ¶Ôij×Ö¶ÎÊý¾Ý½øÐÐÐ޸쬻ò½øÐÐɾ³ý£¬¾ÍÓпÉÄܾͻáÔì³ÉijЩ¿Í»§¶Ë³öÏÖ´íÎó£¬Ó¦¸ÃÈçºÎÈ¥±ÜÃâÄØ£¿ÄÜ·ñÌṩ¾ßÌåÊÂÀý£¬Ð»Ð»
Ôõô»áͬʱÐÞ¸ÄÄØ£¿
......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
±ÈÈ磺
ÊÂÎï1 START
¡£¡£¡£¡£¡£¡£
ÊÂÎï2 START
²åÈëÒ»Õűí
ÊÂÎï2 END
¡£¡£¡£¡£¡£¡£
&n ......