Thursday, June 21, 2012

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. front
SELECT * INTO Destinationdatabase.dbo.tabelname FROM Sourcedatabase.dbo.tabelname
Note: This may be a simple post. But this is useful.
Arun Kumar Munusamy Web Developer

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