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: 473
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