Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Cergy
    Posts
    65

    Question Unanswered: several alias for the same column

    In SQLServer I can't change my SQL column name.

    But I need to see another field name in query tool (Excel)

    How can I do that (alias..., description ?

    Thanks

  2. #2
    Join Date
    Jul 2004
    Posts
    15
    Column alias can be assigned like this using AS keyword:

    Select ColName AS 'First Column'
    From TableName

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •