create copy of table in sql server with data code example

Example 1: copy table sql server

-- Use SELECT ... INTO:
SELECT * INTO my_table_1 FROM my_table;
-- Structure only:
SELECT * INTO my_table_1 FROM my_table WHERE 1 <> 1;

Example 2: how to copy data in sql

INSERT INTO my_table my
SELECT * FROM another_table an
WHERE an.col1 > 10;

INSERT INTO my_table (colA, colB) 
SELECT an.col1 AS colA, an.col2 AS colB FROM another_table an
WHERE an.col1 > 10;