Advertisement

Working with Numbers

  • Jason Brimhall
  • David Dye
  • Jonathan Gennick
  • Andy Roberts
  • Wayne Sheffield
Chapter

Abstract

SQL Server supports integer, decimal, and floating-point numbers. Working with numbers requires an understanding of the types available and what they are capable of. 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.

Keywords

Data Type Decimal Place Decimal Point Round Function Monthly Payment 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Jason Brimhall 2012

Authors and Affiliations

  • Jason Brimhall
    • 1
  • David Dye
    • 2
  • Jonathan Gennick
    • 3
  • Andy Roberts
    • 4
  • Wayne Sheffield
    • 5
  1. 1.UTUSA
  2. 2.FLUSA
  3. 3.MIUnited States
  4. 4.MAUSA
  5. 5.VAUSA

Personalised recommendations