SQL: Three scenarios for inserting query results into another table

One: If the target table to insert does not exist:

Select *  into  from where ...

Two: If you want to insert the target table already exists:

Insert  into Select *  from where condition

Three: If it is a cross-database operation: How to put the atable table of a database, all the things that are queried into the btable table of the B database

Select *  into  from where ...

Similarly, if it is cross-server, it is also possible.

Select *  from #Tmp    -- Query the data for temporary tables drop table #Tmp-- release temporary tables truncate Table -- emptying all data and constraints on the staging table

SQL: Three scenarios for inserting query results into another table