Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24595 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijay dev arya
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 ? | 9 Yes | 1 No |
Post New Answer View All Answers
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
Which are ddl commands?
What are system databases into sql server (2005/2008) : sql server database administration
What is tempdb in sql server?
Explain steps of normalization?
What are the advantages of using stored procedures in sql server?
what are the important architecture components of SSRS?
How to list all stored procedures in the current database using ms sql server?
What is the difference between for xml raw and for xml auto?
Tell me what is the significance of null value and why should we avoid permitting null values?
What are the benefits of normalization?
What is create command?
Is natural join and equi join same?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
