Create a “Last Modified” Column in SQL Server

Some database tables include a “last modified” column, which stores the date and time that the row was last updated. Each time the row is updated, the date is updated to reflect the date and time of that update.

In SQL Server, you can use a trigger to perform this update.

A trigger is a special type of stored procedure that automatically runs when an event occurs in the database server.

You can use the CREATE TRIGGER statement to create a trigger when using T-SQL. This statement can be used to create a DML, DDL, or logon trigger.

Continue reading

How to Pause the Execution of a Statement in PostgreSQL

PostgreSQL includes three functions that allow you to delay the execution of the server process. the execution of a statement.

In other words, you can run a statement and have it pause half way through, before continuing on its merry way.

The three functions are:

These are all very similar, but they work in slightly different ways.

Below are examples of each one.

Continue reading