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