Saturday, March 29, 2014

SQL Query to Copy Table with Data from One Database to another Database

Leave a Comment
Some time in SQL Server you want to copy the table along with data from one database to another. This process of Copying Data along with rows in the table to another Database can be done by using Select *into Command of SQL.

SQL Query Syntax to Copy Data along with structure from one Database to Other Database:


Query: Select * into [Destination Database Name].dbo.[Destination table name] from [Source Database Name].dbo.[Source table name]

0 comments:

Post a Comment