Re: [RadiusNT] SQLServer Column Aliasing

Michael Saunders ( (no email) )
Wed, 18 Aug 1999 18:51:56 +1000

Try select * from TableName
or select [Column Name] from [table] where ......;
----- Original Message -----
From: Danny Sinang <danny@uplink.com.ph>
To: RADIUSNT <radiusnt@iea-software.com>
Sent: Wednesday, August 18, 1999 1:14 PM
Subject: [RadiusNT] SQLServer Column Aliasing

> Hi guys,
>
> Does anyone here know how I can do Column Aliasing in SQL Server ?
>
> I am presently trying to shift to SQL Server from MS Access97.and my ASP
> scripts won't run anymore.
>
> It seems SQL Server does not recognize column aliasing like MS Access
does.
> For example,
>
> Select column1 as [Column 1]
> From mytable;
>
> is erroneous according to SQL Server.
>
> Hope somebody could help me.
>
> - Danny
>
>
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart