Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25583 Views
- I also Faced
- E-Mail Answers
Answer Posted / mohsin mohammed abdul
Delete command deletes the data from the tables .. but can
get back on issue of roll back whereas when you issue
truncate deletes the records and oracle implicitly issues
commit command and even when you issue rollback you won't
get the data back
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
How do I connect to sql server database?
What is the server name in sql server?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
Explain what stored procedure sp_replcounters is used for? : sql server replication
How to return the top 5 rows from a select query in ms sql server?
What is the difference between drop table and truncate table?
What is oltp (online transaction processing)?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Will sql server 2005 allow you to reduce the size of a column?
How to disconnect from a sql server using mssql_close()?
What is Sqlpaging in SqlServer 2005 ?
How to provide column names in insert statements in ms sql server?
What are the different types of upgrades that can be performed in sql server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Explain sql delete command?
