Thursday, March 26, 2009

How to copy structure and data of one table into another table(2 Db's)?

How to copy structure and data of one table into another table(2 Db's)?

SELECT * INTO db2.dbo.test FROM db1.dbo.test

No comments:

Post a Comment