Câu 8: 70-461: MCSA Querying Microsoft SQL Server 2012/2014

You need to build a table structure for a stored procedure to support data entry from a website form. The website form must meet the following requirements: ✑ Users must validate their age as 18 or older to use the website. ✑ Users who leave the date of birth field blank, or who enter an invalid date, must receive an error message. Which two actions should you perform? Each correct answer presents part of the solution.

1. A. Add the CHECK constraint to the table structure.
2. B. Add the DATEPART function to the stored procedure.
3. C. Add the DEFAULT constraint to the table structure.
4. D. Add the SYSDATETIMEOFFSET function to the stored procedure. — đáp án hiện tại
5. E. Add the ISDATE function to the stored procedure. — đáp án hiện tại