Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - What is the maximum value of int type and bigint type in sql server?
What is the maximum value of int type and bigint type in sql server?
The storage size is 8 bytes.

Int integer data (all numbers) from -2 3 1(-2 147 483 648) to 2 31(2147 483 647). The storage size is 4 bytes. The SQL-92 synonym for int is integer.

Smallint integer data from-215 (-32,768) to 215-1(32,767). The storage size is 2 bytes. Tinyint integer data from 0 to 255. The storage size is 1 byte.

Extended data:

Microsoft SQL Server is a comprehensive database platform, which provides enterprise-level data management through integrated business intelligence (BI) tools. Microsoft SQL Server? The database engine provides a more secure and reliable storage function for relational data and structured data, enabling you to build and manage high-availability and high-performance business data applications.

It has the advantages of convenient use, good expansibility and high integration with related software, and can be used across a variety of platforms, from notebook computers running Microsoft Windows 98 to large multiprocessor servers running Microsoft Windows 20 12.

Baidu encyclopedia -sql server