sql:select exclude columns from TABLENAME

Is there a way to exclude column(s) from a table without specifying all the columns?

Google find a communication about sqlSERVER like:

It would be nice to have an EXCEPT operator like the "\" (backslash) in set theory to exclude columns from the output of a select statement (in opposite to the existing EXCEPT operator, which excludes rows instead of columns).

SQL Programmability Team reply this:

Hello, Thanks for your suggestion. We follow the ANSI SQL standard for the Core DML functionality. We do have T-SQL specific extensions to the DML statements but we tend to keep it minimal. So we have no plans to extend the syntax to specify regular expressions or some other patterns for project list items. If you want to you could create your own stored procedure that take the SELECT statement and translates it to actual query using metadata.

As you know ,a good sql script cannot input like this

select * from TABLENAME;(It will waste DB time to search the column first and then is time to get the data.

Which is called Maintenance-light best practice is to specify only the required columns.)

haha,but sometimes i don't wanna list the columns for one unwanted column that really time consuming.Good example:)

/* Get the data into a temp table */
SELECT * INTO #TempTable
FROM YourTable
/* Drop the cloumns that are not needed */
ALTERTABLE#TempTable
DROPCOLUMN ColumnToDrop
/* Get results and drop temp table */
SELECT * FROM #TempTable
DROPTABLE #TempTable

转载于:https://www.cnblogs.com/jnuyao/archive/2013/03/20/2971130.html