TA貢獻1820條經驗 獲得超2個贊
我同意每個人.。但如果我要做這樣的事，我可能會這樣做：
/* Get the data into a temp table */
SELECT * INTO #TempTable
FROM YourTable
/* Drop the columns that are not needed */
ALTER TABLE #TempTable
DROP COLUMN ColumnToDrop
/* Get results and drop temp table */
SELECT * FROM #TempTable
DROP TABLE #TempTable
TA貢獻1815條經驗 獲得超13個贊
Columns
TA貢獻1796條經驗 獲得超4個贊
declare @cols varchar(max), @query varchar(max);SELECT @cols = STUFF (
(
SELECT DISTINCT '], [' + name FROM sys.columns where object_id = (
select top 1 object_id from sys.objects where name = 'MyTable'
)
and name not in ('ColumnIDontWant1', 'ColumnIDontWant2')
FOR XML PATH('')
), 1, 2, ''
) + ']';SELECT @query = 'select ' + @cols + ' from MyTable'; EXEC (@query);舉報