Select all columns except one sql

/* 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

Source: stackoverflow.com

Similar codes

0 vote325 views1 answer
Run mssql server terminal
SQL
0 vote324 views1 answer
Case when with count and combining similar values in sql
SQL
7 votes343 views1 answer
Oracle alter sequence restart start with
SQL
2 votes305 views1 answer
Mysql add boolean column
SQL
0 vote329 views1 answer
Order by in codeigniter query builder
SQL
0 vote325 views1 answer
Dump db only triggers mysql
SQL
0 vote332 views1 answer
Stored function in sql
SQL
0 vote329 views1 answer
Two inner joins sql
SQL
0 vote362 views1 answer
Sql ssrs
SQL
0 vote320 views1 answer
Check sql database table lock
SQL