Sun 4 Nov 2007
Handy SQL Server script
Posted by RobinLayfield under geek stuff
No Comments
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
