integer Max value constants in SQL Server T-SQL?

Posted by AaronLS on Stack Overflow See other posts from Stack Overflow or by AaronLS
Published on 2010-04-29T20:45:38Z Indexed on 2010/04/29 20:47 UTC
Read the original article Hit count: 430

Filed under:
|
|

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?

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 SET UpperRange = int.Max

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql-server-2005