Friday, July 2, 2010

SQL Query - Transaction on DDL

Execute this.
Begin transaction
Create table dbo.t1 (i int);
Rollback transaction

What do you think about the output of following statement?
select * from dbo.t1