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[/sql]