DECLARE @BatchStart DATETIME
SET @BatchStart = GETDATE()

DECLARE @Test1 TABLE (id int)
CREATE TABLE #Test2 (id int)

SELECT * FROM TempDB.sys.tables where create_date >= @BatchStart

DROP TABLE #Test2

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

DECLARE @Test TABLE (
 id INT IDENTITY PRIMARY KEY,
 name VARCHAR(50)
)

INSERT INTO @Test (name)
SELECT name FROM sys.columns

SELECT * from @Test WHERE id between 10 and 200

We walk in the dark places no others will enter
We stand on the bridge and no one may pass