I have a custom database which stores Orders details in Order table.
I have a SharePoint list which stores same Orders details as well.
I would like to,
get Order number from SharePoint List and Query SQL table 'Order' to get the total count of missing records from database (Order table).
Insert data from SharePoint list to Order table in DB, if record doesn't exist in DB.
Thanks in advance.