Is there a way to filter column precison after filling the table?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I would like to use the same stored procedure for two different end uses,
but in one use the user requested that I limit all decimal fields to 3
digits after the decimal point and for Date fields to omit the time of day.

I am not sure we can do this on the SQL end, so I am researching how we
might do it in ADO.Net. Is there a way to modify the precision of a decimal
column to limit the significiant digits once the table has been filled?
Would it work to define the table columns beforehand and then fill it?
 
Hi Eric,

I don't think you can limit the columns. Prehaps you might implement
DataTable events to cut the unnecessary decimals.
 
Back
Top