Create table in SQL Server using union

Question

In mysql we write query as

create table new_table as (select a.* from Table1 a union select b.* from Table2 b)

This syntax doesn't work in SQL Server - what's the way around for creating a table from union in SQL Server?

Answer 1

in SQL Server, you can use SELECT .. INTO

 select a.* 
 into   new_table
 from   Table1 a 

 union 

 select b.* 
 from   Table2 b