Sure, I reformatted as well, but that doesn't explain why my results were different than the posted answer. Here is the query I ran, looks the same as the QOD.

CREATE TABLE T ( ID int NOT NULL, Code varchar(10) NULL)

INSERT INTO T

SELECT 1,'AAAA'

GO

---------------------------------

BEGIN Tran t1

DROP TABLE T

ROLLBACK Tran

GO

---------------------------------

SELECT * FROM T