title: SQL update copied table from original table
body: <p>I'm having 2 tables A and B, they are on 2 different databases, B is a copy of A but A is updated frequently (data can be changed, deleted, or newly inserted) so every time I want to update B I have to drop B then use Import Data... to make a copy of A into B.</p>
  <p>After that, I made a little program that will automatically truncate the table B then copy all data from A to insert into B. However, the data appear to be too big so it took quite an amount of time to fully update table B every time it runs.</p>
  <p>I wonder if there's any other way to shorten the time to complete the task or any SQL query to update table B from A?</p>
  <p>The server belongs to the company so I don't have permission to access SQL Server Agent. and the database version doesn't support creating an SSIS pakage as well</p>