有没有办法得到十进制类型列的小数位数？
您可以查询 information_schema.columns :

select column_name, numeric_precision, numeric_scale 
from information_schema.columns
where table_schema = 'dbo' and table_name = 'my_table' and column_name = 'my_column'

你可以从 sys 物体：

SELECT ct.name AS DataType,
       c.precision,
       c.scale
FROM sys.schemas s
     JOIN sys.tables t ON s.schema_id = t.schema_id
     JOIN sys.columns c ON t.object_id = c.object_id
     JOIN sys.types ct ON c.system_type_id = ct.system_type_id
WHERE s.name = N'Your Schema'
  AND t.name = N'Your Table'
  AND c.name = N'Your Column';