Business Intelligence with SQL Server & ME
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
2 comments:
Fayaz
July 9, 2010 at 10:49 AM
Object invalid!!
Reply
Delete
Replies
Reply
Rajesh
July 9, 2010 at 4:01 PM
Yes, right.
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Object invalid!!
ReplyDeleteYes, right.
ReplyDelete