Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2014
    Posts
    2

    Unanswered: Select specific column in front of star

    Hello,

    In SQL Server I can select a specific column in from of * like so:
    Code:
    select test_column_1,* from testtable1
    I've been googling around and cannot seem to be able to find a definitive answer.

    Thanks,
    Buster

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Dont use the 'star' at all... its just a lazy shortcut define the columns you want in the order you want.

    Code:
    select my, column, list from mytable
    However that really only matters if you provide direct user access to the query results. You can do whatever the heck you like with the resulset in your front end
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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