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.
datetime
B.
datetime2
C.
smalldatetime
D.
timestamp