Exporting table in a specific SQL database to a new database
<p>So I have a table in SQL that's in a database. I've performed sort operations as well as catching a certain amount of records, and now my objective is to input these values into a new database. How can I do this, considering the sort operations? Would it be potentially easier to export the whole table then perform the sort in the new database? I am using SQL 2005.</p>