sql server audit trigger for insert update delete

Classes;Update classes Set name = ' Five class ' WHERE name = ' Class 5 ';The update trigger saves the updated data in the deleted table after the data is updated, and the updated data is saved in the inserted table. # Update column-level triggers if (object_id (' Tgr_classes_update_column ', ' TR ') is not null)Drop

Example of a trigger codes: Code of the insert, delete, and update trigger: Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->-- DBO. trgroups. SQL If exists ( Select * From sysobj

() fromInserted asAINNER JOINLm_sys_shiyanshixinxi asB onA.shiyanshiid=b.shiyanshiidINNER JOINLm_mj_men asC onB.menid=C.menidWHEREA.shifoumoren= 0 andB.isdelete= 0 andC.isdelete= 0; End --Delete if( not exists(Select 1 fromInserted and exists(Select 1 fromdeleted)) begin Delete fromLm_k

Create trigger [updatetest] on [DBO]. [test] For insert, update, delete As Begin Declare @ Isinsert bit, @ Isupdate bit, @ Isdelete bit If exists (select 1 from inserted) and not exists (select 1 from deleted) Set @ isinsert = 1 Else Set @ isinsert = 0 If exists (select 1 from inserted) and exists (select 1 from delet

SQL Server 2008 provides an enhanced SQL command merge for use in the msdn:http://msdn.microsoft.com/zh-cn/library/bb510625.aspx Function: Inserts, updates, or deletes on the target table based on the results of joining with the source table. For example, you can synchronize two tables by inserting, updating, or deleting rows in a table based on differences foun

CustomersSet cust_email = NULLwhere cust_id = 10005--81.2 update all rows in the table: Update all customer email addresses as ' [email protected] 'Update CustomersSet cust_email = ' [email protected] '--81.3 update multiple columns for customer 10005, email address and nameUpdate CustomersSet cust_email = ' [email pr

But sometimes, you can see the logic level, you can write the three triggers, just a little judgment. You can determine whether a trigger is handled by inserting, deleting, or updating according to the following methods: Copy Code code as follows: --Declaring two variables DECLARE @D BIT = 0 DECLARE @i BIT = 0 --If a record is found inside the deleted temporary touch, the old data is deleted IF EXISTS (SELECT top 1 1 DELE

Label:　　 1. Introduction T-SQL (Transact structured Query Language) is the standard SQL extension that is the primary language for program and SQL Server communication. The T-SQL language consists mainly of the following parts: Data definition Language (DDL): Used

XML is added to SQL Server. the Modify () method is xml. modify (insert), xml. modify (delete), xml. modify (replace) corresponds to XML insert, delete, and modify operations. The following XML is used as an example to describe th

Three kinds of insert,update,delete states in a trigger CREATE TRIGGER tr_t_a on t_a for Insert,update,delete if exists (select * from ins

The new Xml.modify () method is added to SQL Server, xml.modify (insert), xml.modify (delete), xml.modify (replace) to insert, delete, and modify the XML. This article takes the following XML as an example to illustrate three type

entry of the index. For each index entry, SQL Server performs an in-place update or is removed and then inserted. SQL Server will use an in-place update whenever possible. However, there are some situations that cannot be updated

XML is added to SQL Server. the Modify () method is xml. modify (insert), xml. modify (delete), xml. modify (replace) corresponds to XML insert, delete, and modify operations. The following XML is used as an example to describe th

XML is added to SQL Server. the Modify () method is xml. modify (insert), xml. modify (delete), xml. modify (replace) corresponds to XML insert, delete, and modify operations.The following XML is used as an example to describe thr

meet the current conditionsSET @myDoc. Modify ('Insertif (count (/root/location/step) Then element step {"This is new step"}Else ()As first into (/root/location) [1] ')SELECT @myDoc;2. Update XML DECLARE @myDoc XML SET @myDoc = ' Laborhours= "1.1" Machinehours= ". 2" >manufacturing steps is described here. SELECT @myDoc; --The value of the LaborHours property in the replacement node location is SET @myDoc. Modify (' Replace value of (/roo

This article introduces mssqlserver to determine whether a trigger is processing an insert, delete, or update trigger. If you need to learn more, refer to. This article introduces how to determine whether a trigger is processing a

Generally, TRIGGER is written. INSERT, DELETE, and UPDATE are written separately. Generally, TRIGGER is written. INSERT, DELETE, and UPDATE

However, sometimes, you can view the logic of the process and write the three into a trigger, only to make a slight judgment.You can determine from the following method whether the trigger is triggered by processing the insert, delete, or update:Copy codeThe Code is as follows:-- Declare two variablesDECLARE @ d bit =

Copy Code code as follows: Create Trigger Tr_mastertable_update On mastertable After update As If update ([Type])--triggers this trigger when the Type field is updated INSERT INTO masterlogtable Select Id , (case [Type] when 1 Then ' Type1 ' When 2 Then ' Type2

Table creation: Create Table user_info (Id integer not null,Username varchar (30) not null,Password varchar (20) not null,Createdate date not null,Status integer not null,Constraint pk_user_info primary key (ID)); Create Table user_info_temp (Id integer not null,Username varchar (30) not null,Password varchar (20) not null,Createdate date not null,Status integer not null,Constraint pk_user_info_temp primary key (ID)); Trigger Syntax: Create or repl