SELECT FROM table except certain columns

[griffitd]

Hi

Is it possible to select all columns from a table excluding certain columns?

i.e.

SELECT * from Table1 Except Columns(ID, EmployeeName)

??

Thanks in advance

 

[1DMF]

Short answer No, however, you can mimic it if you want...

have a look here :

http://stackoverflow.com/questions/...olumn-using-select-except-columna-from-tablea

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music