Tip: Put the stored procedure under a shortcut.
Select table/view, press shortcut and all columns are listed in the output window. Copy/Paste all the columns you need at once.
Instead of this script you could also use the sp_help procedure in the same way, however this script has two advantages:
1): It also works on temp tables
2): It also lists columns with a comma in front of it, so that saves you some time typing. Idem for brackets .