petesql · May 16, 2018 21:45
diff --git a/who_is_active_tutorial.sql b/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', '[email protected]' )
 --COMMIT
	--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', '[email protected]' )
	--COMMIT