who_is_active_tutorial

who_is_active_tutorial.sql

--Create a test database.
CREATE DATABASE myDatabase

--Change database context.
USE myDatabase
GO

--Create a test table.
CREATE TABLE myTable ( firstname VARCHAR(50), surname VARCHAR(50), email VARCHAR(255) )

--Start explicit transaction but do not commit.
BEGIN TRANSACTION
INSERT INTO myTable VALUES ( 'pete', 'whyte', 'peter_whyte@outlook.com' )
--COMMIT