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"->"Ñ¡Ôñ±£´æÎļþÃûºÍ·¾¶"->È»ºó´ò¿ª¸ÃÎļþµ½²éѯ·ÖÎ
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
СµÜÏÖÔÚSwingÔÚÁ¬½ÓÊý¾Ý¿âÉÏÓöµ½Ò»µãÎÊÌ⣬ÇëÎÊSwingÀïÃæµÄʼþºÍSQLserverÊý¾Ý¿âµÄÁ¬½ÓÓÐʲôºÃµÄ×ÊÁÏÊéÍÆ¼öÂð£¿
Õâ¸öÓ¦µ±Ã»ÓÐÊ²Ã´ÌØ±ð,ÓëÆäËûµÄ±à³ÌÒ»Ñù.
JDBC
ÇëÎÊÔÚSwingÖмÓÔØ±³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿
......
´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
ÎÒ°²×°µÄ08°æ±¾ÊÇEnterprise£¬µ±ÎÒÔ¶³ÌÁ¬½Óʱ¿ÉÒÔ½øÈëµÇ½Óû§£¬µ«¾ÍÊDZéÀú²»ÁËÊý¾Ý¿â£¨Ìáʾ¸ÃÓû§ÔÚµ±Ç°°²È«ÉèÖÃϲ»¿ÉÒÔ·ÃÎÊÄ¿µÄÊý¾Ý¿â£©£¡
È»¶øÎÒÈ¥ÆäËüµçÄÔÉÏÓøÃÓû§ÊÇ¿ÉÒԵǼ ......