Friday, 26 August 2011

Insert Values from One table anothertable in another database

INSERT INTO database1.dbo.table (column1, column2)
SELECT column1, column2 FROM database2.dbo.table

No comments:

Post a Comment