Can we rollback records deleted by a truncate statement?
Answer Posted / mp
No, because it is a DDL.
We can only rollback DML statements, right?
Is This Answer Correct ? | 6 Yes | 9 No |
Post New Answer View All Answers
How can a user-defined datatype be created?
How do we know if any query is retrieving a large amount of data or very little data?
How does Report Builder support Analysis Services cubes?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Can a unique index be created on a column, which contains null?
What are the restrictions applicable while creating views? : SQL Server Architecture
how to avoid cursors? : Sql server database administration
What is difference between delete & truncate commands?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is difference between count (*) and count 1?
How to enter date and time literals in ms sql server?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What are the advantages of user defined function?
Write query to return all rows sql?
What do you mean by recursive stored procedure?