如何从表中选择十进制精度和比例值?

本文介绍了如何从表中选择十进制精度和比例值?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

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.