By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,534 Members | 865 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,534 IT Pros & Developers. It's quick & easy.

Specifying Precision and Scale for SQLDecimal in User Defined CLR SQL Server Function

P: n/a
How in the hell does one specify the precision and scale for the
SQLDecimal type? I am writing a user defined CLR SQL Server function
and one of the function parameters is a decimal value which in SQL
Server would be type numeric(18,6), but the only type that seems to be
an equivalent on the VB 2005 side is SQLDecimal, but there seems no way
to set the precision and scale for this (outside of using a new
constructor, which is not allowed for a function parameter list). It
appears by default that the scale for the SQLDecimal type is 0, so when
I call the function with say 0.01, the value is truncated to 0, which
causes all to go to shit. Can anyone help? The VB documention blows
when it comes to the SQLTypes.

Thanks,

Mar 24 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.