Showing posts with label copy table. Show all posts
Showing posts with label copy table. Show all posts

Tuesday, April 3, 2007

Creating a Backup Copy of a Table in SQL 2005

I used the following sql to create a backup copy of a table in SQL Server 2005:

select *
into tablename_bkup
from tablename