title: integer Max value constants in SQL Server T-SQL?
body: <p>Are there any constants in T-SQL like there are in some other languages that provide the max and min values ranges of data types such as int?</p>
  
  <p>I have a code table where each row has an upper and lower range column, and I need an entry that represents a range where the upper range is the maximum value an int can hold(sort of like a hackish infinity).  I would prefer not to hard code it and instead use something like <code>SET UpperRange = int.Max</code></p>