Monday, 21 May 2012

Copy data from one table to another


Copy Data from one table to another when Database is different,

Here is simple query for this :

INSERT INTO dbo. NewTable(FieldName)
SELECT FieldName FROM existingdb.dbo.existingtable;

SELECT * INTO  NewTable  FROM  existingdb.dbo.existingtable;

No comments:

Post a comment