New SQL Tables

new_sql_table.sql

CREATE TABLE table_name (
	 id INT PRIMARY KEY IDENTITY(1,1)
	,title VARCHAR(15)
	,created DATETIME NOT NULL DEFAULT GETDATE()
	,updated DATETIME NULL
	,is_active INT NOT NULL DEFAULT 1
);
GO
 
CREATE TRIGGER trg_UpdatedTableName
ON table_name
AFTER UPDATE
AS
BEGIN
	SET NOCOUNT ON;
	IF TRIGGER_NESTLEVEL() > 1 RETURN;
 
	UPDATE table_name
	SET updated = GETDATE()
	FROM inserted i
	WHERE table_name.id = i.id
 
END;
GO