Hi.
I'm confuse on how I will create my temporary table.
Need some clarification here.

I want to create a temporary table that will hold some column and values. And later on I would alter/update the table to add another column and data with respect to the existing columns.

ammm... how will I do this?

Is it better to create my table were first at hand I will define the columns it needs and just update it or let the select statement define its columns which means I need to alter the temporary table to add the new column?

  1. What database?
  2. How temporary?
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.