SQL Server Architecture Interview Question:

Explain the Microsoft SQL Server delete command?

Submitted by: Administrator

Delete command removes records one at a time and logs into the transaction log.
It can be used with or without where clause.
The records can be rolled back.
It activates trigger.
It doesn't reset the identity of the column.
Submitted by: Administrator