Max value for datatype

• carlos.tapadinhas

  Ten Centuries

  Points: 1058

  More actions

  September 25, 2008 at 7:10 am

  #382829

  Hello guys,

  Is it possible to know which is the max value for a datatype? but making a query... Of course this dont result, but something like this Select MAX(Money)...

  Best Regards

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  September 25, 2008 at 7:28 am

  #876983

  Check following link

  http://groups.google.nl/group/microsoft.public.sqlserver.programming/browse_thread/thread/46512c2691da4607/6743f4aea485c6d1

• Jeremy Leasor

  SSC Veteran

  Points: 234

  More actions

  September 25, 2008 at 7:30 am

  #876984

  Not sure if this is what you are looking for.

  The only thing I could think of is(keep in mind if the data type is not assign to a value the return will be null):

  DECLARE @bigint as bigint

  DECLARE @int as int

  DECLARE @smallint as smallint

  DECLARE @tinyint as tinyint

  SET @bigint = 1

  SET @int = 1

  SET @smallint = 1

  SET @tinyint = 1

  SELECT @bigint,length = DATALENGTH(@bigint)

  SELECT @int,length = DATALENGTH(@int)

  SELECT @smallint,length = DATALENGTH(@smallint)

  SELECT @tinyint,length = DATALENGTH(@tinyint)

• carlos.tapadinhas

  Ten Centuries

  Points: 1058

  More actions

  September 25, 2008 at 7:37 am

  #876998

  Thanks for answer,

  As i can see on the link u send, no one knows how to specifies the maxium values for various numeric datatypes, i know that int is 2147483647 but where can i find, the max value for Money for example?

  And then i create one function where i store that information...

  Thanks Again