SQL Server Architecture Question:
Explain the Microsoft SQL Server delete command?
Answer:
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.
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.
| Previous Question | Next Question |
| Explain the truncate command? | What is Master Database? |