So, I have this habit where I copy tables into tempdb...basically, b/c it's easy to do SELECT * INTO tempdb..mytable. For some reason, my boss would prefer me to DECLARE TABLE variables in my scripts instead (no one uses these except for me). I'm reluctant b/c I don't want to spell out table definition every time. Some of these tables have a lot of fields. Anyway I can use DECLARE TABLE and not have to spell out the exact table definition?