© Elizabeth Noble 2020
Elizabeth NoblePro T-SQL 2019https://doi.org/10.1007/978-1-4842-5590-2_1

1. Data Types

Elizabeth Noble
(1)
Roswell, GA, USA
 
Data types are the building blocks that make the foundation of writing efficient and performant T-SQL. While many data types are either a number or a string, there are also a variety of data types that do not fit into either category. When selecting the right data type, it is important to understand what the data type is and when to use it.

Number Data Types

While numbers may all seem to be the same, T-SQL segments numbers into different kinds of data types. These data types can include whole numbers or numbers with decimal places. Numbers are also categorized by either being exact or approximate. Understanding ...

Get Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.