quote:
At the end of the script, the original writer needed to return all column values except one.
SELECT *
INTO #temp
FROM tablename
ALTER TABLE #temp DROP COLUMN unwantedcolumn
SELECT * FROM #temp
DROP TABLE #temp
Far away is close at hand in the images of elsewhere.
Anon.