Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 9093 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / valarmathi
truncate delete all records from the table and it is auto
commit. We can't able to rollback the data after performing
truncate operation.
delete statement delete the specific or all records from
the table. But we can able to rollback the deleted record
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What type of Index will get created after executing the above statement?
How to write a query with a right outer join in ms sql server?
List the data types available in mssql?
What is molap and its advantage? : sql server analysis services, ssas
Explain use of expression builder.
What is the significance of null value and why should we avoid permitting null values?
What is a field in a table?
Explain about temporary stored procedure?
What are constraints in microsoft sql server?
Explain a join?
What is SQL Azure Federations?
What is filtered index?
How do I make a resultset scrollable?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is cursor in ms sql server?
