Copying tables from one database to another in SQL server
Here is the code to copy tables from one database to another in SQL server.
SELECT *
INTO Destinationdatabase.dbo.tabelname
FROM Sourcedatabase.dbo.tabelname
Note:
This may be a simple post. But this is useful.
Share Post
Arun Kumar MunusamyWeb Developer
Follow me on:
Morbi aliquam fringilla nisl. Pellentesque eleifend condimentum tellus, vel vulputate tortor malesuada sit amet. Aliquam vel vestibulum metus. Aenean ut mi aucto.
No comments:
Post a Comment