

If your tool / programming language doesn't appear in the below list, which means we have not documented use case but as long as your tool supports ODBC Standard, our drivers should work fine. Below is the small list of most popular tools / programming languages our Drivers support. Which mean the majority of BI Tools / Database Engines / ETL Tools already there will support native / 3rd party ODBC Drivers. ZappySys ODBC Drivers built using ODBC standard which is widely adopted by industry for a long time. JOIN (SELECT * FROM OPENQUERY(MY_LINKED_SERVER_NAME, 'SELECT * FROM $')) dbtbl_2 on dbtbl_1.id=dbtbl_2.id Now if you want to update particular fields records only then you need to query like this. In the upper step, we see how to insert and update new records.WHERE id in (SELECT id FROM #temp_tblMyAPiData) SELECT * into #temp_tblMyAPiData FROM OPENQUERY(MY_LINKED_SERVER_NAME, 'SELECT * FROM $')ĭELETE FROM. To do that, we need to query like below SQL queries.At the last insert all new API data into the database table.Now let's delete the old records from the database table which are updated.To do that first we need to insert the new API data into the "#temp_tblMyAPiData" temporary database table.Let's insert and update records into the already created table "tblMyAPiData".
