Creating Insert and Update SQL on the fly RRS feed

  • Question

  • Hi

    I need to update or insert records from one SQL Server table to another depending on if records with PK values already exist in the destination table or not. The fields can change between the two tables over time. Therefore I need to make Insert and Update sql strings on the fly to update fields that have the matching field names between the two tables.

    My question is how can I retrieve the list of fields in the two tables to create SQL strings?





    Saturday, April 16, 2011 8:52 PM