Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24559 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Delete command removes the rows from a table based on the
condition that we provide with a WHERE clause. Truncate will
actually remove all the rows from a table and there will be
no data in the table after we run the truncate command.
| Is This Answer Correct ? | 39 Yes | 6 No |
Post New Answer View All Answers
What are the different types of collation sensitivity in sql server?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is de-normalization in sql database administration? Give examples?
What is the maximum size of a row in sql server?
Which are new data types introduced in sql server 2008?
Which is better statement or preparedstatement?
How do you run a trace?
What Is Rdbms?
What are the authentication modes in sql server? How can it be changed?
Explain about builtinadministrator?
What is lock escalation and what is its purpose?
what is database replicaion? : Sql server database administration
State the difference between local and global temporary tables?
What is public role in sql server?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
