Pages

Friday, August 22, 2014

How to select all columns except only one column in sql server

DECLARE @columnList Varchar(1000), @SQLStatment VARCHAR(4000)
SET @columnList = ''
select @columnList = @columnList + Name + ' , ' from syscolumns where id = object_id('sample_tablename') AND Name != 'Id_columnnames'
SELECT @SQLStatment = 'SELECT ' + Substring(@columnList ,1,len(@columnList)-1) + ' From sample_tablename'
EXEC(@SQLStatment)