Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Transaction with DDL statments

Author  Topic 

khalik
Constraint Violating Yak Guru

443 Posts

Posted - 2010-04-06 : 02:43:16

When i started learning SQL transaction work only on DML staments only. nothing on DDL.

but recently i found out that with in transaction if i create a table and if i rollback the table the table does not exits...

do we have any more such changes done if any one has a link which list such changes it would be helpful.

========================================
Project Manager who loves to code.
===============
Ask to your self before u ask someone

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2010-04-06 : 08:50:44
Try following the links in my signature. I am not sure what your question is.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page
   

- Advertisement -