INSTEAD OF trigger and OUTPUT clause

Do you know your getdate()?

This article takes a closer look at SQL Server getdate() and sysdatetime() functions.

Values <> null

Statement evaluation precedence

Analysing a T-SQL Query

A quick way to find recently entered datetime entries in tables

Sometimes you need to scan a large number of datetime columns for most recent access.

A round number

Play with NULLIF

Using REPLACE in an UPDATE statement

This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very handy with an UPDATE statment.

Convert seconds to a timestring

This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'