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


Please Help Members By Posting Answers For Below Questions

What is trigger in salesforce?

674


how to invoke a trigger on demand? : Sql server database administration

732


What is TDS(Tabular Data Stream) Gateway?

115


What is a full text index?

668


What are functions in the sql server?

794






how many layers of tcp/ip protocol combined of? : Sql server database administration

720


Can you explain powershell included in sql server 2008?

669


What is the purpose of object explorer and its features? : sql server management studio

811


Where is localdb stored?

731


Define tempdb database?

753


How to Check if table exists in sql server?

790


What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

741


What does the update command do?

786


What are the diifferences between the ms sql server vs mysql?

888


How to select all columns of all rows from a table with a select statement in ms sql server?

748