Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24966 Views
- I also Faced
- E-Mail Answers
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
How to optimize stored procedure optimization?
Explain security with sql azure?
Write a query for primary key constraint with identity key word?
What is wide table?
What is Federation and Federation Member?
What is a join in sql?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
How can you insert values in multiple rows using one Insert statement?
What is normalization? Describe its different types.
Suggest a method of joining two tables.
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
What is default constraint in ms sql server?
What is cursor in ms sql server?
How to transfer an existing table from one schema to another schema in ms sql server?
What are the properties and different types of sub-queries?
