Which data type should you use?

You are a database developer on an instance of SQL Server 2008. You need to add a column to your AssemblyDetail table to hold a date and time value. You want the time portion to include to highest data precision possible, but you do not want to store time zone information.
Which data type should you use?
A. smalldatetime
B. datetimeoffset
C. datetime2
D. datetime

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.