I've worked on several projects and thought of feature that I'd like to see added to SQL. I've searched everywhere and can't seem to find a place to put my suggestion so I'm posting it here in hopes that someone will see and consider it.
I've been writing some queries lately where I need all but one or two fields and it's most annoying, especially with bigger tables, to have to put in all the columns in the select statement just to eliminate one so what I propose is a SELECT EXCLUDE statement.
Here's the syntax:
SELECT * EXCLUDE [column] FROM [table]
This would select all columns minus the one(s) you exclude. Much simpler.
So how about it guys at MS?
View Complete Post