This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SQL Server Insert and Update

parvez_shaikh19
New Contributor

‎11-27-2019 05:49 AM

Hello All,

We are developing a solution in which the data from an excel sheet is required to be inserted in the SQL Server. This excel may contain updates for previously inserted rows and may contain net new rows to be inserted, which can be determined by the unique id present in the excel.

Could you please let me know if you have a solution to identify update vs insert in the data from Excel.

Thanks in Advance

0 Kudos
Reply
1 REPLY 1

petar_rajchinos
New Contributor III

‎11-27-2019 12:46 PM

Hi parvez.shaikh19,

If there is a unique key in the excel and the SQL server table the easiest way to detect changes is using Diff snap (https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438546/Diff). If that doesn’t help than you need to manually create logic for getting the rows from the excel and searching the row in the table. In order to make the search easier and faster you can hash each row (Digest.md5(col1+col2)) from the excel and do the same thing with the table rows and compare hashes instead of columns.

Regards,
Petar

0 Kudos
Reply