CREATE TABLE #StartEndTime(TableType nvarchar(100),StartTime datetime, EndTime Datetime)
INSERT INTO #StartEndTime VALUES('TempTable', GETDATE(),NULL)
GO
EXEC dbo.TempDB_TempTableTest
GO 1000

UPDATE #StartEndTime SET EndTime =GETDATE() WHERE TableType ='TempTable'

WAITFOR DELAY '00:00:05'
GO

INSERT INTO #StartEndTime VALUES('MemoryOptTable', GETDATE(),NULL)
GO
EXEC dbo.MemoryOptTableTest
GO 1000

UPDATE #StartEndTime SET EndTime =GETDATE() WHERE TableType ='MemoryOptTable'

WAITFOR DELAY '00:00:05'
GO

INSERT INTO #StartEndTime VALUES('PhysicalTable', GETDATE(),NULL)
GO
EXEC dbo.PhysicalTableTest
GO 1000

UPDATE #StartEndTime SET EndTime =GETDATE() WHERE TableType ='PhysicalTable'

WAITFOR DELAY '00:00:05'
GO

INSERT INTO #StartEndTime VALUES('VariableTable', GETDATE(),NULL)
GO
EXEC dbo.MemoryOptVarTable
GO 1000

UPDATE #StartEndTime SET EndTime =GETDATE() WHERE TableType ='VariableTable'

WAITFOR DELAY '00:00:05'
GO

INSERT INTO #StartEndTime VALUES('Memory Opt VariableTable', GETDATE(),NULL)
GO
EXEC dbo.MemoryOptVarTable
GO 1000

UPDATE #StartEndTime SET EndTime =GETDATE() WHERE TableType ='Memory Opt VariableTable'

SELECT TableType , DATEDIFF (MILLISECOND ,StartTime,EndTime) AS Duration FROM #StartEndTime
GO

DROP TABLE #StartEndTime
GO