Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25107 Views
- I also Faced
- E-Mail Answers
Answer Posted / amita
Delete command only delete the rows from the table but the
schema of the table yet remains.Whereas Truncate command
delete the rows along with the tale's schema from the
memory permanently.
| Is This Answer Correct ? | 3 Yes | 28 No |
Post New Answer View All Answers
What is nonclustered index on computed columns?
What do you mean by authentication modes in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is db stored procedure?
What are SSL and TSL protocols?
What is subquery? Explain the properties of a subquery?
Which is the latest version of sql server and when it is released?
1 01 101 01010
How to list all field names in the result set using mssql_field_name()?
How do you drop an index?
What number aggregate functions are accessible there in sql?
How to create a view with data from multiple tables?
What is the difference between a view and a stored procedure?
Is it possible in sql table to have more than one foreign key?
What command must you use to include the not null constraint after a table has already been created?
