How to use decimal statement to determine the number of decimal places and the number of integers when building a table

33213321

How to use decimal statement to determine the number of decimal places and the number of integers when building a table

lj0917

CREATE TABLE [dbo]. [Tab1] (
[a] [int] NULL,
[b] [decimal] (10, 2) NULL
) ON [PRIMARY]
GO

fanfan1980

decimal and numeric
A numeric data type with fixed-point precision and decimal places.

decimal [(p [, s])] and numeric [(p [, s])]

Fixed-point precision and decimal places. With maximum precision, valid values ​​range from-10 ^ 38 +1 to 10 ^ 38-1. SQL-92 synonyms for decimal are dec and dec (p, s).

p (accuracy)

Specify the maximum number of decimal digits that can be stored to the left and right of the decimal point. The precision must be a value from 1 to the maximum precision. The maximum accuracy is 38.

s (number of decimal places)

Specify the maximum number of decimal digits that can be stored to the right of the decimal point. The number of decimal places must be a value from 0 to p. The default number of decimal places is 0, so 0 <= s <= p. The maximum storage size varies based on accuracy.

落日圣骑

Create a new table in the Enterprise Manager, enter the field name, select the data type as decimal, in the "Columns" tab below, enter "2" for "Decimal Places", "Accuracy" does not need to change or change according to your needs Too.