Can you tell me the difference between DELETE & TRUNCATE commands?
By admin on Mar 13, 2007 in Ms Sql Server Interview Questions
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.
