You are designing a data storage solution for a transactional application. You need to
ensure that each row in a table records the date and the time that the row was written. The
time must be as precise as possible. Which data type should you use?

A.
timestamp

B.
smalldatetime

C.
datetime

D.
datetime2