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?

  • March 4, 2009 at 2:33 am

    #952957

    Yet another way:

    DECLARE @excluded_columns TABLE (name SYSNAME)

    DECLARE @table_name SYSNAME

    DECLARE @columns NVARCHAR(MAX)

    SET @table_name = 'Person.Contact'

    -- Excluded columns

    INSERT INTO @excluded_columns VALUES ('Suffix')

    INSERT INTO @excluded_columns VALUES ('rowguid')

    SET @columns = ''

    SELECT @columns = @columns + ', ' + QUOTENAME(name)

    FROM sys.columns

    WHERE object_id = OBJECT_ID(@table_name)

    SET @columns = RIGHT(@columns, LEN(@columns) - 2)

    EXECUTE ('SELECT ' + @columns + ' FROM ' + @table_name)

    Best regards

    Flo