Sql updating multiple tables at once
Taught by Andy Leonard, published author, Data Philosopher, and Biml Hero from Farmville, Virginia. You’re a SQL Server DBA who is ready to advance to the next level in your career but aren’t sure how to fully master your environment and drive the right architectural changes. statement can be accomplished in one of two ways, primarily depending upon which version of SQL Server you are using.
A PL/SQL stored procedure that is implicitly started when an INSERT, UPDATE or DELETE statement is issued against an associated table is called a trigger.
You can update one record, and you can delete one record.
But you can also update whole sets of records at once, and in very powerful ways. For example, you can delete rows in one table depending on whether or not they exist in another table.
When transaction processing is applied to a query, Access first performs a "dry run" of the query during which it writes all the changes to a temporary log file but does not make any permanent changes to the database.
If the query finishes its task without any problems, the changes noted in the log file are applied and the job (the transaction) is completed.