RE: Oracle Computed column datatype

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: WebService Client not authenticating through Proxy Server
    ... Thanks for pointing me to those articles. ... snippet requires that the URL of the proxy server be specified. ... If we can possibly help it, we'd like to avoid needing the user to specify ... > When you browse the Web service in IE it will be making Http Get and Http ...
    (microsoft.public.dotnet.framework.aspnet.webservices)