I have bound a "Decimal" field to my DataGridView control.I've gotten precision and scale of this column's value but i am in wonder how to get these values declared in SQL for this field? Thanks and waiting for your replies ...:((
I have bound a "Decimal" field to my DataGridView control.I've gotten precision and scale of this column's value but i am in wonder how to get these values declared in SQL for this field? Thanks and waiting for your replies ...:((
select numeric_precision, numeric_scale from information_schema.columns where table_catalog = 'MyDatabaseName' and table_name = 'MyTableName' and column_name = 'MyColumnName'