apexsql

Text: An auxiliary tool for writing SQLToday, with the help of my colleague, I downloaded a tool: ApexSQL Edit, maybe I am ignorant, I do not know there is such a good tool, it can help me when I type SQL, the name of the table and the column name.Also can help me to format the SQL statement, just like the above SQL, if you write very messy, you can choose your SQL, and then choose Format, it is formatted as above.In addition, it also provides a block

There is a need to find a tool to query the SQL Server history operation log, such as accidental deletion, misoperation, etc., online search a lot, not a reliable. Of course, exclude themselves from writing SQL records operation log, I do not understand the SQL language. There are tools available to recommend, thank you. Log Explorer for SQL ServerSupport to SQL2005, the above is not supported. SQL Server comes with management--sql server logsLogged in and error logs Powerful SQL Ser

Use the ApexSQL recover tool for recovery. The tutorials are as follows:http://solutioncenter.apexsql.com/zh/%E6%B2%A1%E6%9C%89%E5%A4%87%E4%BB%BD%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B% e6%81%a2%e5%a4%8d%e4%b8%80%e4%b8%aa%e8%a2%abdrop%e7%9a%84%e8%a1%a8%e7%9a%84%e6%95%b0%e6%8d%ae/Thanks to the tool developer, otherwise daoteng the data again n long time no longer.To despise myself, to do things is too imprudent.Be sure to do a regular backup of your datab

do an update the original value operation?CheckpointGOUPDATETSETB= 'E'WHEREA=5; -- View Logs SELECT [Current LSN], operation, Context,[Transaction ID], Allocunitname fromFn_dblog (NULL,NULL); -- View Dirty data Select * fromsys.dm_os_buffer_descriptorswheredatabase_id= db_id() andIs_modified= 1Order bypage_id;The results are as follows:8. What happens if we update a different value?UPDATETSETB= 'Z'WHEREA=1; -- View Logs SELECT [Current LSN], operation, Context,[Transaction ID], Allocunitname