Backup a single table with its data from a database in sql server 2008

Question

I need to take a backup of a single table along with its data from a database in the SQL Server using a script.

How can I able to do it?

Answer 1

The following query will help you to take a backup of the table along with its data.

select * into mytable_backup from mytable

This will make a copy of table mytable, and every row in it called mytable_backup.

Looking for SQL Tutorial? Join the SQL Course to gain more knowledge on SQL.