Working with Numbers
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.
11-1. Representing Integers
You are writing T-SQL or creating a table, and you want to represent integer data in a binary format.
Choose one of the four integer ...