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

Re: Strage difference between precision in literals

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Strage difference between precision in literals
Date	2022-04-26 20:26 +0200
Organization	Erland Sommarskog
Message-ID	<XnsAE85CFFF8BA43Yazorman@127.0.0.1> (permalink)
References	<20220423190412.a205fc87d4859bba4556212f@gmail.com> <XnsAE84DF8AE8C27Yazorman@127.0.0.1> <20220426132146.ac3b20b81af37ef0943603c6@g{oogle}mail.com>

Show all headers | View raw

Anton Shepelev (anton.txt@g{oogle}mail.com) writes:
> I think your outer `CAST' is superfluous because it can-
> not increase actual precision.
> 

Yeah, but from a distance I couldn't tell whether you want a decimal
or a float result, so I added the cast.

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

Thread

Strage difference between precision in literals Anton Shepelev <anton.txt@gmail.com> - 2022-04-23 19:04 +0300
  Re: Strage difference between precision in literals Erland Sommarskog <esquel@sommarskog.se> - 2022-04-25 21:58 +0200
    Re: Strage difference between precision in literals Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-04-26 13:21 +0300
      Re: Strage difference between precision in literals Erland Sommarskog <esquel@sommarskog.se> - 2022-04-26 20:26 +0200

csiph-web