That or if you just need a few rows you can write an insert statement.
If you want to create a new table and you have a backup of the database that had the original table in question, and a test database to restore that backup to you can write a insert which I've included an example of below.
Create Table dbo.<your new table name>(
<Columns> (Ex: [Name] [char] (15) NOT NULL)
)
Insert into dbo.<your new table name>
SELECT <columns from other table that match colums in new table created>
FROM <database name>.dbo.<original table name>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.