Q: Emp table had an employee with salary 2000. I issued an update statement to set the salary to 3000. Then I issued a create table statement. However the create table command errored out. I want to rollback the earlier update statement. Can I do that?

Add comment

Votes: 1

Comments: 0

ALL DDL statements are auto-commit. That means whenever you execute a DDL statement, all prior transactions get commited. Please note that the commit is issued before excuting the DDL. So even if the DDL statement errors out, commit would have happened.

Others in this Category

	What are the different index configurations a table can have?
	Q: Please explain the concepts of transaction, commit and rollback
	Q: how to know the days or months or years between two employees in emp table?
	What is a Scheduled Jobs or What is a Scheduled Tasks?
	How to copy the tables, schema and views from one SQL Server to another?
	What are the properties of the Relational tables?
	What is LINQ?
	How would you handle error in SQL SERVER 2008?
	What is sub-query? Explain properties of sub-query?
	What do you mean by Table Sample?
	» More articles