Answer E is correct. The only command that will leave the table behind is one that copies data directly into a table from the current database. The #, ##, and @ identifiers are used solely for variables and create no permanent table. Anything created in tempdb is temporary by definition because tempdb is erased every time the server starts. For more information, see the following sources:
|