What is the difference between truncate and delete statement?
- 6 Answers
- 6633 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / vasu
Both Truncate and delete deletes the rows from a table .
But we cant use where clause in truncate statement . While
doing delete operation all the deleted rows are logged in
the transaction log . It reduces the perfomance . In
truncate operation no transaction logging is happening .
Delete is Autocommited but Truncate is Not .
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Explain the benefits of user-defined functions?
Tell me what is the significance of null value and why should we avoid permitting null values?
What is sql profiler. What are the default templates with it? : sql server database administration
How to achieve Paging of records in SQL SERVER?
What is a print index?
How to configure odbc dsn with different port numbers?
Which are new data types introduced in sql server 2008?
Is there any difference between the primary key and unique key?
What are the advantages of using stored procedures in sql server?
What are the properties of the relational tables?
What is the difference between a function and a trigger?
can you instantiate a com object by using t-sql? : Sql server database administration
Define outer join?
