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

microsoft.public.dotnet.framework.adonet

27 Feb 2006 8:41 PM

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?

28 Feb 2006 8:46 AM

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.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote

"Eric" <someone@nospam.com> wrote in message
news:ucvwQ39OGHA.648@TK2MSFTNGP14.phx.gbl...
>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?
>
>
>
>
>