Carlos Sanchez

Carlos Sanchez

  • NA
  • 264
  • 0

Stored Procedure

Apr 24 2006 5:11 PM

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


Answers (2)