You need to ensure that the application automatically stores the current date and time data when a record is inserted or updated, regardless of the database platform

Your company is developing an application. The database platform for the application will
be vendor-independent. You need to ensure that the application automatically stores the
current date and time data when a record is inserted or updated, regardless of the database
platform. What should you do?

Your company is developing an application. The database platform for the application will
be vendor-independent. You need to ensure that the application automatically stores the
current date and time data when a record is inserted or updated, regardless of the database
platform. What should you do?

A.
Use Entity Framework and DateTime.Now.

B.
Create a database column that has a default value of GETDATEQ.

C.
Create an INSERT trigger that uses the GETDATEQ function.

D.
Use the datetime2 data type.



Leave a Reply 0

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