DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Copy Table From One Database To Another In MsSQL

06.08.2005
| 58313 views |
  • submit to reddit
        This works in Microsoft SQL Server; don't know about other databases.

SELECT * INTO NewTable FROM existingdb.dbo.existingtable;