How to copy table structures and data using SQL statements

Use SELECT... in SQL SERVER... INTO statement

The following types can be used:

1. Full table backup: for example, SELECT * INOT t1 FROM titles

2. Back up some columns of the table (write the column list without writing *) or some rows (with the WHERE condition)

Example: SELECT title_id, title, price INTO t2 FROM titles-partial Columns

SELECT * INTO t2 FROM titles WHREE price> 10-partial rows

SELECT title_id, title, price INTO t2 FROM titles WHREE price> 10-partial rows and partial Columns

3. Only copy the table structure: for example, SELECT * INOT t1 FROM titles WHERE 1 = 2

4. the query result is from multiple tables, for example:

SELECT title_id, title, pub_name INTO t3

FROM titles t inner join publishers p

ON t. pub_id = p. pub_id

5. select * into: name of the database to be copied. DBO. Table name from original database name. DBO. Table Name