Abstract
SQL Server supports integer, decimal, and floating-point numbers. Working with numbers requires an understanding of the types of numbers available and what they are capable of doing. Implicit conversion rules sometimes lead to surprising results from seemingly simple-to-understand expressions. The recipes in this chapter show some of the more common operations as well as techniques for guarding against unexpected and unwanted results.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Jason Brimhall, Jonathan Gennick, and Wayne Sheffield
About this chapter
Cite this chapter
Brimhall, J., Gennick, J., Sheffield, W. (2015). Chapter 11: Working with Numbers. In: SQL Server T-SQL Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0061-2_11
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0061-2_11
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0062-9
Online ISBN: 978-1-4842-0061-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books