SQL Alias Problem

V

Vincent

In access:
' select (1+2) as T1, ([T1]*2) as T2, ([T2] *3) as T3 from tbl_test ' is fine
But why it can not be run at mssql 2000.

How can I achieve this function in mssql 2000?
 
D

Duane Hookom

This isn't a SQL Server news group. However, I would not even use the syntax
in Access even if it works. I would use:

select (1+2) as T1, ((1+2)*2) as T2, (((1+2)*2) *3) as T3 from tbl_test

This should be more reliable in all flavors of SQL.
 
S

Sylvain Lafontaine

This works on Access because the final result of the select is interpreted
as VBA code. However, doing so may lead to a severe loss of performance on
many occasions; for exemple when used in a JOIN or a WHERE clause.

You must be very carefull every time you are using a VBA function or an
expression in an Access query statement.

S. L.
 
Top