i have a table called OldTable in my SqL Server, but i would like to append a new data that is sitting in another server into the OldTable. How would i do that using open query method? Here is my situation:
OldTable:- this is the table that i would like to add some more or new data and it is my current server
NewTable:- this is a linked server and i want to bring the data in this table into the OldTable
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!