This will copy a table, structure and data from SQL server database to another.
Damn handy!
SQL:
-
SELECT * INTO TargetDatabase.dbo.MyTable
-
FROM SourceDatabase.dbo.MyTable