SQL Server Architecture Question: Download Questions PDF
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.
Download MS SQL Server Architecture Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain the truncate command? | What is Master Database? |