Home Forums SQL Server 2005 T-SQL (SS2K5) Is there a way to select all columns except one or two columns? RE: Is there a way to select all columns except one or two columns?

  • Hi,

    Personly I din't like my own idea, but with dynamic sql you can have a shot-

    DECLARE @COLUMNS VARCHAR(1000)

    DECLARE @Col1 varchar(100), @Col2 varchar(1000)

    SET @COL1 = 'DATE'

    SET @COL2 = 'dateId'

    SELECT @Columns = SubString (( SELECT ', ' + QUOTENAME(Column_name )

    from INFORMATION_SCHEMA.columns

    WHERE Table_name ='TimeDimension'

    AND COLUMN_NAME != @col1

    AND COLUMN_NAME != @COL2

    FOR XML PATH ( '' ) ), 3, 1000)

    EXEC('SELECT '+ @Columns +' FROM TimeDimension')

    John Smith