Which data type should you use to to ensure that each row in a table records the date and the time that the row was written?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *