Is there a syntax that will allow me to exclude certain columns versus explicitly stating every column that I want?

Whats the problem in specifying the columns you need, you can generate the SQL queries using SSMS without much hassle and it will be create issue in case some column is added to source tables.

---

Thanks and Regards, Prajesh Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.