migrate sql table another database
snippet in sql

migrate sql table another database

user2602

INSERT INTO dbo.YourTableNameHere
   SELECT *
   FROM [SourceServer].[SourceDatabase].dbo.YourTableNameHere