如何从表中选择十进制精度和比例值? [英] how to select decima precision and scale value from table?

问题描述

您好如何从表格中选择小数精度和小数位值?

Hi how to select decimal precision and scale value from table?

USE DBNAME SELECT column_name 'Column Name',data_type 'Data Type',CHARacter_maximum_length 'Maximum Length',data_decimal(p,s) 'DECIMAL PRECISION',COLUMNPROPERTY (OBJECT_ID(Table_Name),Column_Name,'IsIdentity') as FieldIdentity FROM information_schema.columns WHERE table_name = 'TBNAME' ;

与此有关，如果数据类型是十进制，我也希望该值也可以..如何列出.

例如:decimal(4,2)

如何从表中选择精度和比例尺


[edit]整理出代码块-OriginalGriff [/edit]

with this if the data type is decimal i want that values also ..how to list .

eg:decimal(4,2)

how to select that precision and scale from table


[edit]Code blocks sorted out - OriginalGriff[/edit]

推荐答案

什么是data_decimal(p,s)?

选中NUMERIC_PRECISION和NUMERIC_SCALE.

What is data_decimal(p,s)?

Check NUMERIC_PRECISION and NUMERIC_SCALE.

这篇关于如何从表中选择十进制精度和比例值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！