Uint16, Uint, byte, sbyte, double in C# is what in SQL 2000 ?

• Ronvy

  Mr or Mrs. 500

  Points: 597

  More actions

  May 17, 2007 at 1:40 am

  #124060

  Could anyone please lend a helping hand as I need to know how can I use a data type in SQL 2000, the same as that of Uint16 in C#.

  Similarly,

  Uint16

  Uint

  byte

  sbyte

  double

  Thanks a lot in advance.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 17, 2007 at 7:19 am

  #707125

  .antares686 th, .antares686 td {border:1pt solid #000000} 

  Short Name	.NET Class	Type	Width	Range (bits)	SQL Datatype (Closest Match)	Constraint to use (if needed in table definition)
  byte	Byte	Unsigned integer	8	0 to 255	tinyint
  sbyte	SByte	Signed integer	8	-128 to 127	smallint	[ColName] Between -128 AND 127
  int	Int32	Signed integer	32	-2,147,483,648 to 2,147,483,647	int
  uint	UInt32	Unsigned integer	32	0 to 4294967295	bigint	[ColName] Between 0 AND 4294967295
  short	Int16	Signed integer	16	-32,768 to 32,767	smallint
  ushort	UInt16	Unsigned integer	16	0 to 65535	int	[ColName] Between 0 AND 65535
  long	Int64	Signed integer	64	-922337203685477508 to 922337203685477507	bigint
  ulong	UInt64	Unsigned integer	64	0 to 18446744073709551615	decimal(20,0)	[ColName] Between 0 AND 18446744073709551615
  float	Single	Single-precision floating point type	32	-3.402823e38 to 3.402823e38	real
  double	Double	Double-precision floating point type	64	-1.79769313486232e308 to 1.79769313486232e308	float
  bool	Boolean	Logical Boolean type	8	True or false	bit
  decimal	Decimal	Precise fractional or integral type that can represent decimal numbers with 29 significant digits	128	±1.0 × 10e-28 to ±7.9 × 10e28	decimal (can go 38 significant in SQL need to limit to 29 for here.)