in tsql : how can i copy a temp table #myTable to a global table ##myTable (same columns) ?
Posted on 2016-11-15
i create two temp tables in a storeproc.
at the end of the SP, i'd like to copy one of my temp tables to the global tables.
Is it possible to do this easily ? like changing a pointer ?
if yes how ?
do i have to create the table then loop over it to insert all data ?
if this is the case i'd appreciate the sql to do it.
thank you in advance for your help.