create trigger for insert update delete sql server

RETURN NULL; end;$body$ language 'plpgsql' volatile cost 100; Description The above code is a stored procedure (Procedure) There is $ body $, which can be something other than body, such as diff_user_list. The following code creates a trigger and is associated with the above stored procedure. create trigger diff_user_lis

Copy codeThe Code is as follows:Create trigger TgNameOn tbFor updateAsIf update (recommend)BeginUpdate tb set commenddate = (getdate () from tb inner join inserted on tb. vlistid = Inserted. vlistidEnd Recommend indicates the updated field.The key lies in the Inserted TableTwo special tables are used in the trigger statement: deleted table and inserted Table.The

. Explicitly start the transaction:Start TRANSACTION: Start transactionROLLBACK: Rolling backCommit: Submit #注意提交后就不能回滚6.2. No explicitly initiated transaction:Autocommit: Can achieve automatic submission, each operation is submitted directly;Recommendation: Explicitly use transactions, and turn off autocommit;SET autocommit=0;SET @ @autocommit;6.3. Transaction Save PointSave point: SavePoint nameRollback to save point: ROLLBACK to name7. Isolation Level:Read-uncommitted: Read not submittedRead-

MySQL Create data tableThe following information is required to create a MySQL data table: Table name table field Name Define each table field GrammarThe following is the general SQL syntax for creating MySQL data tables:(column_name column_type); In the following example we will create a data tab

StaticString[] minsertsqlfornoteclass={"INSERT into Noteclass (className) VALUES (' Default classification [private] ');", "INSERT into Noteclass ( ClassName) VALUES (' reading notes [private] '); "," INSERT into Noteclass (className) VALUES (' Electronic data [public] '); "}; PrivateDBHelper (Context context, Cursorfactory Factory) {Super(context, Mdbname, Fact

the following work: Check if the object already exists in the session. If the object is not present, call Save (object). If the object exists, check to see if the object has changed. If the object changes, call Update (object). Take a look at the following example to illustrate this situation, write the Saveorupdatecustomer () method at the data access layer, save the Update Custo

inserting insertThe data structure of the MongoDB document is basically the same as JSON. All data stored in the collection is in the Bson format. Bson is a binary form of a class JSON storage format, referred to as binary JSON.First we select the databaseLet's define a document firstThen we go into today's topic, insert a document into the collection, insert it in two ways, one is to

In-depth introduction to Mybatis series (7) --- insert, update, delete, and mybatis --- mapper in mapper ing file configuration In the previous article, the introduction and configuration of Mybatis series (6) --- objectFactory, plugins, and mappers briefly end the configuration of mybatis. Starting from this article, we will introduce the configuration of the ER

Multi-table View example --=================================================== --Create Test View --======================= ============================ Create Or Replace view T as select T1.t11 F1, t1.t12 F2, t2.t22 f3 nbsp; from T1,t2 Where t1.t11=t2.t11; 3.3 Multi-table View trigger example --=================================================== --