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

You develop a Microsoft SQL Server database that contains a table named Employee, defined as follows: You need to create a view that contains two computed columns representing the month and the year of the [HireDate] of each Employee. Which function should you use?

1. A. DATENAME( )
2. B. CONVERT( )
3. C. TRYDATEDIFF( )
4. D. MONTH( ) and YEAR( ) — đáp án hiện tại