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

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?
 
M

Miha Markic [MVP C#]

Hi Eric,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding a column to a table 7
Precision error converting from .NET Double to SQL Decimal with Sq 0
Excel How to preserve column fields in a specific order in a pivot table? 2
Filling in fields to a partially complete record in a table using a form 0
Is there a way of not showing zero totals in a pivot table? 2
databound inherited textbox can't keep changes to me.text 3
What is the fastest way to update all rows of a table in a dataset 1
Is there a way to only format numbers that have digitsafter decima 6

Top