StationX
Start free

Browse › T-SQL Database Query

Can you Use Data Types and Functions in Transact-SQL?

Advanced

Part of T-SQL Database Query Topic: Data Science

Access

StationX Infrastructure Labs — 3 attempts per lab

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab

Already have access? Sign in.

New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.

What you'll do

In this challenge, you will write several Transact-SQL (T-SQL) queries by using data types and functions.

  1. Launch Microsoft SQL Server Management Studio (SSMS)
  2. Develop queries that use string parsing to extract data
  3. Develop more specific queries that will use the FORMAT function for formatting date and time data
  4. Explore queries that use the DATEDIFF and DATEADD functions for performing calculations on date and time data

Note: Once you begin a challenge you will not be able to pause, save, or return to your progress. Please ensure you have set aside enough time to complete the challenge before you start.

  • ⏱ About 45 minutes