SELECT * EXCEPT

by

As others have said, it is not a good idea to do this in a query because it is prone to issues when someone changes the table structure in the future. However, there is a way to do this… and I can’t believe I’m actually suggesting this, but in the spirit of answering the ACTUAL question…

Do it with dynamic SQL… this does all the columns except the “description” column. You could easily turn this into a function or stored proc.

declare @sql varchar(8000),
    @table_id int,
    @col_id int

set @sql="select "

select @table_id = id from sysobjects where name="MY_Table"

select @col_id = min(colid) from syscolumns where id = @table_id and name <> 'description'
while (@col_id is not null) begin
    select @sql = @sql + name from syscolumns where id = @table_id and colid = @col_id

    select @col_id = min(colid) from syscolumns where id = @table_id and colid > @col_id and name <> 'description'
    if (@col_id is not null) set @sql = @sql + ','
    print @sql
end

set @sql = @sql + ' from MY_table'

exec @sql

More Related Contents:

  1. I want to find out how much zero come after 1 in SQL
  2. Query to get username from child table with specific condition
  3. Count work days between two dates
  4. Only inserting a row if it’s not already there
  5. Unpivot with column name
  6. Split comma separated column data into additional columns
  7. Group by minimum value in one field while selecting distinct rows
  8. Rails raw SQL example
  9. MySQL “NOT IN” query
  10. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  11. How to use Oracle ORDER BY and ROWNUM correctly?
  12. Convert Xml to Table SQL Server
  13. SQL Call Stored Procedure for each Row without using a cursor
  14. SQL string comparison, greater than and less than operators
  15. Polymorphism in SQL database tables?
  16. Sql PIVOT and string concatenation aggregate
  17. What is the purpose of constraint naming
  18. Get previous and next row from rows selected with (WHERE) conditions
  19. Return multiple columns and rows from a function PostgreSQL instead of record
  20. Multiple Ranks in one table
  21. Comma separated values in a database field
  22. Postgres error updating column data
  23. SQL not displaying null values on a not equals query?
  24. Can SQL Server Express LocalDB be connected to remotely?
  25. SQL LIKE condition to check for integer?
  26. move cells left in sql if left contains null and right contains value
  27. Temporal database design, with a twist (live vs draft rows)
  28. SQL query with distinct and sum
  29. Why do SQL Server Scalar-valued functions get slower?
  30. Querying Active Directory from SQL Server 2005

Leave a Comment