Interested to Buy Any Domain ? << Click Here >> for more details...
Can we rollback records deleted by a truncate statement?
- 3 Answers
- 8898 Views
- CarrizalSoft Technologies, United Healthcare, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anand
yes,we can ROLLBACK records deleted by truncate if we had
executed BEGIN TRAN first
ex:
Begin Tran
truncate table tablename
ROLLBACK
with out "Begin Tran" you can not rollback
| Is This Answer Correct ? | 18 Yes | 4 No |
Answer / mp
No, because it is a DDL.
We can only rollback DML statements, right?
| Is This Answer Correct ? | 6 Yes | 9 No |
What are partitioned views and distributed partitioned views?
What is for xml in sql server?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
How to create a new table in a given schema?
How do you run a trace?
Can sql servers link to other servers like oracle?
What is the difference between a "where" clause and a "having" clause?
what is the difference between openrowset and openquery?
What is the use of =,==,=== operators?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
If a stored procedure is taking a table data type, how it looks?
What are unicode character string data types in ms sql server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
