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

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

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005
Date	2011-08-12 22:25 +0200
Organization	Erland Sommarskog
Message-ID	<Xns9F3FE42F6260Yazorman@127.0.0.1> (permalink)
References	<bc35893b-4e20-4fe7-81b3-1472057cfb8d@u12g2000prc.googlegroups.com> <Xns9F3FE0E9C817AYazorman@127.0.0.1> <c0ef80f9-5dbc-48e2-973b-3187782c0be7@v9g2000pri.googlegroups.com>

Show all headers | View raw

xo (xo5555ox@gmail.com) writes:
> Thanks for the respond.   I would like to provide the error message so
> hopefully it will help.

I know perfectly well what the error is. It's a very common question on the 
newsgroups.

My previous post presented the cure for the problem, so know you know 
how to fix your query! (And let's hope that isnumeric does not find 
any false positives!

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

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