Campos calculados.

Es una decisión de diseño del producto:

"The expression can be a noncomputed column name, constant, function,
variable, and any combination of these connected by one or more
operators. The expression cannot be a subquery."

Gustavo Larriera, MVP
Uruguay LatAm
http://sqljunkies.com/weblog/gux/
Este mensaje se proporciona "COMO ESTA" sin garantias y no otorga ningun
derecho / This posting is provided "AS IS" with no warranties, and
confers no rights.



"José Antonio" wrote in message
news::

Hola, porqué una columna calculada no puede formar parte de la formula de

otra columna calculada?

Gracias

Mira Gux,

curiosidades de los campos calculados:

drop table t
go
create table t (
id int identity
, c0 as id*1./1
, c1 as id*1./2
, c2 as id*1.0/2
, c3 as id*cast(1 as numeric)/2
)
go
insert into t default values
go
select
id,
c0, id*1./1 as c0_computed,
c1, id*1./2 as c1_computed,
c2, id*1.0/2 as c2_computed,
c3, id*cast( 1 as numeric)/2 as c3_computed
from t


/*

id c0 c0_computed c1
c1_computed c2 c2_computed c3
c3_computed
1 -.000000 1.000000 NULL
.500000 .500000 .500000 .500000
.500000

*/


Eladio Rincón
SQL Server MVP

Solid Quality Learning (http://www.solidqualitylearning.com)
"Comparte lo que sabes, aprende lo que no sepas", FGG

Consulte el histórico del grupo en Google
http://groups.google.com/groups?gro....sqlserver

¿Te interesa participar en las reuniones
del grupo de Usuarios de SQL-Server y .NET
Se harán en levante de España, (Alicante o Murcia)?

"Gustavo Larriera [MVP]" wrote in message
news:

Es una decisión de diseño del producto:

"The expression can be a noncomputed column name, constant, function,
variable, and any combination of these connected by one or more
operators. The expression cannot be a subquery."

Gustavo Larriera, MVP
Uruguay LatAm
http://sqljunkies.com/weblog/gux/
Este mensaje se proporciona "COMO ESTA" sin garantias y no otorga ningun
derecho / This posting is provided "AS IS" with no warranties, and
confers no rights.



"José Antonio" wrote in message
news::
> Hola, porqué una columna calculada no puede formar parte de la formula

de

>
> otra columna calculada?
>
> Gracias