Log Analysis Tool-apexsql Introduction

Original: Log analysis tool-apexsql Introduction

Usage scenarios: Abnormal changes in business data, through the code analysis can not come out, forced to use the log to analyze

: Http://www.apexsql.com/Download.aspx?download=log

Key points of Use:

1. The principle of the log causes him to not display the original SQL, only to record the changes, this is the mechanism of the log itself
2. The transaction ID can be used to determine whether the same transaction, but to understand its modification process or need business experience.
3. Records when a transaction occurs, does not record the initiator's program name and client information

Sample code:

CREATE TABLE [dbo]. [Tabletest]    (      [Id] [uniqueidentifier] null,      [Name] [nvarchar] () null,      [age] [int.] NULL    ) on  [PRIMARY] Goinsert into  [dbo].[ Tabletest]        ([Id], [Name], [age]) VALUES  (NEWID (), ' Lucifer ', ") Goinsert into  [dbo].[ Tabletest]        ([Id], [Name], [age]) VALUES  (NEWID (), ' Lucifer1 ', ") Goinsert into  [dbo].[ Tabletest]        ([Id], [Name], [age]) VALUES  (NEWID (), ' Lucifer2 ', ") goupdate  [tabletest]set Age     = Age + 10WHERE   [age] In (goupdate)  [tabletest]set Age     = age + 10WHERE   [age] in (+) godelete
   [tabletest]go

Log Analysis Tool-apexsql Introduction