Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #591

Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005

Show all headers | View raw

xo wrote:
> Hello -
>
> I have a strange problem when casting value under 64-bit sql server
> 2005 vs under 32-bit sql server 2005.
>
> I got two servers.  One has 32-bit SQL server 2005 standard edition
> (version 9.00.3073.00) on Windows NT 5.2 (3790) with NT INTEL x86.
> The second server has 64-bit SQL server Enterprise edition (version
> 9.00.4035.00) on Windows NT 5.2 (3790) with NT AMD64.
>
> The problem came when I tried to cast value under 32-bit SQL server
> 2005, the result gets queried out.  But when the same sql got run,  it
> prompted conversion error - "Error converting data type varchar to
> numeric." under the 64-bit server.
>
> I tried cleaned up the data and it still gives the same error.
>
Please show us how to reproduce this symptom. You need to provide a script
that we can run on our servers to see the error you are getting. If the
problem occurs when using variables, that would enable you to easily create
a repro script:

declare @v1 <somedatatype>, @v2 <someotherdatatype>;
set @v1=<somevalue>;
set @v2=cast(@v1 as <someotherdatatype>);

Replace the <...>s with the actual data types and values required to
reproduce your symptom and post it here.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 10:33 -0700
  Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-08-12 14:56 -0400
    Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 13:05 -0700
      Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-08-12 16:56 -0400
  Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Erland Sommarskog <esquel@sommarskog.se> - 2011-08-12 22:06 +0200
    Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 13:17 -0700
      Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Erland Sommarskog <esquel@sommarskog.se> - 2011-08-12 22:25 +0200
        Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 14:31 -0700
          Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Erland Sommarskog <esquel@sommarskog.se> - 2011-08-13 12:59 +0200

csiph-web