How to format Temp Table Statements
I realize this is an older thing now, but I'm new to mode and very interested in the Temp Table idea. But I can't find any information on the specifics of how to use it.
First question, can it be used if I have Read-Only database access ? This is really what I want as this is what I have...
Second, if the first question is true, I'm getting errors in my attempts to format the query.
What is the proper format?
SELECT * INTO TEMP TABLE temp1 FROM real1 doesn't seem to work on my end.
Appreciate any help.