Answer C is correct. If you are going to create a process in which a new table is going to be generated on every execution, you need to use SELECT INTO to generate a table and a variable to hold the name of the table. INSERT (INTO) assumes that the table has already been created. # and ## are used for temporary tables. For more information, see the following sources:
|