You can't do the equivilent of "SELECT * EXCEPT DbId FROM myTable" - there is no mechanism in Sql for that.
The good practice way to do it is to name all the columns you do wish to retrieve, in the order you want them:
SELECT Column1, Column3, Column2 FROM myTable
The reduces waste in the transfer, as it doesn't get columns you aren't interested in, and specifies the order if you use a numeric index when you access the retrieved data.
You could do it by creating a temporary table, copying the whole table into it, and then dropping the DbId column from the temporary table before returning the whole of that, but t would be incredibly inefficient!
SELECT * INTO #Temp FROM myTable
ALTER TABLE #Temp DROP COLUMN DbId
SELECT * FROM #Temp
DROP TABLE #Temp
Submit an article or tip