Timeline for How 'Select * into' works into background?
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 18, 2018 at 12:49 | comment | added | John K. N. |
Was the table empty before you copied (inserted) the data? Was the table non-existant before you copied the data? You might be better off perofrmaing a DROP TABLE temp_b before you run the SELECT ... part.
|
|
| May 18, 2018 at 10:56 | answer | added | Brent Ozar | timeline score: 4 | |
| May 18, 2018 at 9:41 | comment | added | Akina | I don't believe. Miracles do not happen. The amount or records inserted (while no hidden factors affected - constraints, triggers, etc.) is to be equal to the amount of records selected. | |
| May 18, 2018 at 9:37 | review | First posts | |||
| May 18, 2018 at 12:40 | |||||
| May 18, 2018 at 9:32 | history | asked | Ganesh | CC BY-SA 4.0 |