• subscribe
June 01, 2002 12:00 AM

T-SQL Tutor Project

SQL Server Pro
InstantDoc ID #25175

Here's a small homework assignment to help you continue to improve your T-SQL syntax. You can find the answers online in the DateTimeDataHomework.sql script file at http://www.tsqlsolutions.com, InstantDoc ID 25175. Applying the tools and tips I gave you in this column, use the Northwind sample database to write a query that displays the date on which each order was placed. Make sure you include the date format in the column header, remove the time, display a four-digit year, and arrange the data in order showing the most recently ordered items first. Sample Table A shows headers and the first two rows of output.



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here