Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - If a field in the database is an exact number of 1 bit, what floating-point data type should I choose?
If a field in the database is an exact number of 1 bit, what floating-point data type should I choose?
bigint

A giant integer, which is an eight-section integer with an accuracy of 19 bits. Macro integers range from-9,223,372,036,854,775,808 to.

9,223,372,036,854,775,807。

binary

binary system

a little

byte

tea

character type

testing time

Time type

decimal

Decimal data type Decimal variables are stored as unsigned integers of 96 bits (12 bytes) and divided by the power of 10.

This scale factor determines the number of digits to the right of the decimal point, ranging from 0 to 28. When the scale factor is 0 (no decimal places),

The maximum possible values are+/-79,228,162,514,264,337,593,543,950,335. For 28 decimal places, the maximum value is

+/-7.922816251426437593543950335, and the minimum non-zero value is+/-0.0000000000000000001.

flotage

Single precision type

picture

Picture type

Internationalorganizations (same as international organizations)

Do plastic surgery

money

Currency type

Enchar

Returns a unicode character with a given integer code according to a character type defined by the unicode standard.

ntext

Text type

digital

Decimal(numeric) is a synonym for accurately storing numerical values.

The decimal data type can store up to 38 numbers, all of which can be placed to the right of the decimal point. Decimal data type storage

Accurate digital expression; Do not store approximations.

nvarchar

Varchar character data type.

real

Floating-point and actual data

Floating-point and real data types are called approximate data types. In terms of approximate numeric data types, floating-point and real data are used as follows.

Follow the IEEE 754 standard.

smalldatetime

Short date type

smallint

Short integer

Small fund

Short-term currency type

Sql _ variable

A data type used to store various data types supported by SQL Server (excluding text, ntext, image, timestamp and

Sql_variant)。

text

text

time stamp

/f? Kz=9 10620 16 is introduced here.

tinyint

Tinyint uses the exact numeric data type of integer data, ranging from 0 to 255, and stores 1 byte.

Unique identifier

The uniqueidentifier data type can store a binary value of 16 bytes, which is similar to globally unique identifier (GUID). GUID is unique.

Binary number: No two computers in the world will generate duplicate GUID values. GUID is mainly used for multi-node and multi-computer computing.

In a computer network, a task must have a unique identifier. In SQL, ROWGUIDCOL means that the new column is the globally unique identification column of the row. about

Only one uniqueidentifier column can be assigned to each table as ROWGUIDCO column. The ROWGUIDCOL property can only be assigned to uniqueidentifier.

row

Uniqqueidentifier is a globally unique identifier.

varbinary

Variable length binary data. N can be a value between 1 and 8,000. Max indicates that the maximum storage size is 2 3 1- 1 byte. Large storage capacity

As small as the actual length of input data +2 bytes. The length of the input data can be 0 bytes. ANSI SQL Synonym for Varbinary

This word is binary.

Variable length string

Variable length non-unicode character data. The value range of n is 1 to 8000. Max indicates that the maximum storage size is 2 3 1- 1 byte.

. The storage size is the actual length of the input data plus 2 bytes. The length of the input data can be 0 characters. Varchar's ISO and

Semantic words are character-changing or character-changing.

That's basically it.