DECLARE @tableName VARCHAR(128)
DECLARE @hideColName VARCHAR(128)
SET @tableName = 'Books'
SET @hideColName = 'BookName'
DECLARE testCursor CURSOR FOR
SELECT syscolumns.name
FROM
syscolumns LEFT JOIN sysobjects ON syscolumns.id = sysobjects.id
WHERE
sysobjects.name = @tableName
AND syscolumns.name != @hideColName
DECLARE @colName VARCHAR(128)
DECLARE @query VARCHAR(512)
SET @query = ''
OPEN testCursor
FETCH NEXT FROM testCursor
INTO @colName
WHILE @@FETCH_STATUS = 0
BEGIN
IF @query != ''
SELECT @query=@query + ', ' + @colName
ELSE
SELECT @query = @colName
FETCH NEXT FROM testCursor
INTO @colName
END
EXEC ('SELECT ' + @query + ' FROM ' + @tableName)
CLOSE testCursor
DEALLOCATE testCursor