Hi folks,
How do I move the data from one table in a database to another table in a different database? I found the following code on this site but my field names are not the same in the two tables so I can't use the '*':
Insert into database2.dbo.table2 select * from database1.dbo.table1
any help would be greatly appreciated.
Rich
How do I move the data from one table in a database to another table in a different database? I found the following code on this site but my field names are not the same in the two tables so I can't use the '*':
Insert into database2.dbo.table2 select * from database1.dbo.table1
any help would be greatly appreciated.
Rich