Hi everyone!
I need a query to retrieve data from a server and insert them into another server. I was thinking to create a stored procedure, but how can I pass the server name as parameter from C# and how can I concatenate it to the command?
The query I need is something like the following:
INSERT INTO Server1.Table SELECT * FROM Server2.Table
Thank you in advance