Can you tell me the difference between DELETE & TRUNCATE
commands?

Answer Posted / guest

Delete command removes the rows from a table based on the
condition that we provide with a WHERE clause. Truncate will
actually remove all the rows from a table and there will be
no data in the table after we run the truncate command.

Is This Answer Correct ?    39 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why we use trigger in sql server with example?

748


What new changes are being made in SQL Server?

842


Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

797


What are group functions in query statements in ms sql server?

783


What is pivot and unpivot?

825


What is the need for indexing?

714


what authentication modes does sql server support? : Sql server database administration

771


Write a sql query to display the current date?

871


Why should we go for stored procedures? Why not direct queries?

814


When a primary key constraint is included in a table, what other constraints does this imply?

805


What do you mean by sql server agent?

758


Is sql server free?

718


How does a profiler work?

702


What is the cartesian product of table?

781


Explain indexed views?

773