SQL Server Architecture Question:

Download Job Interview Questions and Answers PDF

Explain the Microsoft SQL Server delete command?

MS SQL Server Architecture Interview Question
MS SQL Server Architecture Interview Question

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.

Download MS SQL Server Architecture Interview Questions And Answers PDF

Previous QuestionNext Question
Explain the truncate command?What is Master Database?