As the name said, the server events which contains Insert word (Row_Inserting and Row_Inserted) are being used to add or to insert the new record(s), whereas the server events which contains Update word (Row_Updating and Row_Updated) are being used to update the existing record(s).This is the very basic things you should know before we go further.Now let's take a look at bit closer to these two server events: Row_Updating and Row_Updated.As the name said, Row_Updating is fired when the existing record(s) is(are) being updated or saved into the current table.This event is usually useful if you want to execute your own code after you want to make sure the record(s) is(are) truly inserted/added into database.In more specific case, let's say you want to insert or update another table based on the inserted record's ID. You should be able now to compare between Row_Inserting and Row_Inserted server events.
In this article I want to explain you about this server events so that you will use them in the right place, and also, at the right time.
Now let's take a look at bit closer to these two server events: Row_Inserting and Row_Inserted.
As the name said, Row_Inserting is fired when the new record(s) is(are) being added or inserted into the current table.
You can even cancel the inserting/adding process by returning FALSE and display the certain message if the new record(s) is(are) not valid.
Row_Inserting is useful if you want to implement your own business logic that must be complied before the record(s) is(are) added into the database.