it is especially useful, if you need a table to be online all the time, but want to load lots of data to it (e.g. full reload). Then you can create it in a, say 'temp' schema. When finished, just swap the tables using the aforementioned command 😀
That would work as a "3 name" swap. Not sure how you'd do it with only 2 names. Repointing a synonym is seems easier.
Of course, I could be wrong and would love to see a coded example of how you do it. Even an old dog like me still likes learning different tricks.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not."
When you put the right degree of spin on it, the number 3|8
is also a glyph that describes the nature of a DBAs job. 😉
How to post code problems
Create a Tally Function (fnTally)