Data Types: Decimal Values, Date and Times - T-SQL Step by Step Course - Lesson 11 | SQL courses

Duration: 16:34 min

Summary: In this video, we will continue our data type discussion. Of course there are more data types that we can use than we already listed. These data types will allow us to work with decimal values and date and times. It is important to understand the scale and precision of decimal data types to make sure we are declaring the variable correctly. In some cases, when the data precision is not critical, we can declare variables of type ‘real’ and ‘float’. Today, we will also discuss the different ways we can declare variables when it comes to date and time. Finally, we will see an example of how we can convert from one type to another using ‘cast’.

Technologies and Resources: T-SQL, SQL Server 2012 Express, AdventureWorks 2012.