RE: Oracle Computed column datatype

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Kevin,

Those articles date back to 2002,2003 and apply to SQL Server 7.0. I am
using SQL Server 2000 V8.00.818 SP3. Are you telling me that this problem has
not been corrected in SQL2k ? There is no workaround at all ? Isn't there a
way to specify the column type fo computed columns ? Isn't there a registry
parameter specifying datatype for number columns ? There is no way to control
this behavior ?

Stephane

"Kevin Yu [MSFT]" wrote:

> Hi SP,
>
> Thanks for your detailed explanation. Yes, I have reproduced that on my
> machine with linked server.
>
> Based on my research, this is a known issue. Would you please try to
> specify both precision and scale for the number column instead of only one
> value. This might be the only solution on this issue, because Oracle
> handles Numeric columns differently from other databases. You can check the
> following two KB articles for more information on this.
>
> http://support.microsoft.com/?kbid=243027
> http://support.microsoft.com/?kbid=221552
>
> HTH.
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>
>
.

Relevant Pages

  • Re: ActiveX CAB Problems
    ... Hmm... ... it looks as if some of the articles I was thinking about ... specify that or even which version of Windows Update it is referring to ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Did native Americans cultivate Lime tree?
    ... > i meddelandet ... >> Please specify. ... > That part will be in one of my articles. ...
    (sci.archaeology)
  • Re: Snapshot Repl. Failing with Foreign Key Constraints
    ... includes stored proc. ... I have tried to specify that the stored procs are kept and receive the ... > When you are specifying your articles, click on the browse button to the ... > Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: container - browse to file - set location
    ... You're free to specify the "no archive" bit of course, ... with you that real names and email addresses are worth the spam risk. ... I want to keep control myself about articles that I ... But Google or Microsoft shall not profit forever from ...
    (comp.databases.filemaker)
  • Re: create a clone of an existing Bitmap without using the clone method.
    ... Find great Windows Forms articles in Windows Forms Tips and Tricks ... >> you to specify the Pixel GraphicsUnit otherwise the image will be ... >>> That is, pixel for pixel, the original and the drawn images should be ...
    (microsoft.public.dotnet.framework.drawing)