Can you tell me the difference between DELETE & TRUNCATE
commands?
Answer Posted / afzal_aziz
http://weblogs.sqlteam.com/mladenp/archive/2007/10/03/SQL-
Server-Why-is-TRUNCATE-TABLE-a-DDL-and-not.aspx
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Do you know concepts and capabilities of sql server?
How to loop through result set objects using mssql_fetch_array()?
how can a database be repaired? : Sql server administration
What is transaction server distributed transaction?
Explain the steps to use transact-sql cursor?
How to execute a sql statement using odbc_exec()?
How to create new databases with "create database" statements?
How to use values from other tables in update statements in ms sql server?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What is the purpose of indexing?
what are isolation levels? : Sql server database administration
List types of tables in SQL Azure?
Can we deploy SSRS reports on our personal website?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What is dbcc?