Home Forums SQL Server 2008 T-SQL (SS2K8) SQL Query to select one row and fill missing columns from another matching row. RE: SQL Query to select one row and fill missing columns from another matching row.

  • October 2, 2012 at 4:50 am

    #1544299

    kk 93815 (10/2/2012)

    also is it possible to auto return all columns in the table or we need to explicitly specity all the columns in a select query?

    You should always specify the columns you want in case more columns are added to the table - this will change your query results.

    Its also easier & clearer to read.