Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-18 : 09:20:09
|
Lorenzo writes "Hi,
Sorry for this somewhat simple question, but I searched your FAQ and couldn't find any mention about it. I'd like to rename the columns of a query after processing the query so that I can refer to it through the new names. I remember having seen some code looking like "SELECT Field1, Field2, Field3 FROM MyTable AS Name1, Name2, Name3" but it is not working (SQL SErver 7.0).
Any tip ?
Thanks a lot." |
|
|
|
|
|
AS Statement