Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22944 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / monal
Delete doesn't reset identity column seed if you have 1
identity column in the table.
Truncate resets identity column seed to the original value.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What command would you use to add a column to a table in sql server?
Explain about Normalization?
What is a trigger? Why we need it?
Can a synonym name of a table be used instead of a table name in a select statement?
What is use of except clause? How does it differ from not in clause?
How you can get the list of largest tables in a database?
Explain the difference between delete,drop and truncate in SQL Server?
Write the SQL query to drop, truncate and delete table.
What is the cartesian product of the table?
What language is sql server written in?
What is a with(nolock)?
Can we linked SharePoint to a SQL database?
How do I edit a stored procedure in sql server?
Explain a join?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
