I'm trying insert/update data for table T1(int id,char name, float data), which has unique a index on
SQLBulkOperation(SQL_ADD) to add records to the table, and
SQLBulkOperation(SQL_UPDATE_BY_BOOKMARK) to update them.
Now my use case is that I have to update records if they already exist and insert if not. For this, MySQL provides
INSERT INTO ... ON DUPLICATE KEY UPDATE.
How to implement the same in SQL Server? Is there any other efficient way to do this?
libmsodbcsql-13.0.so.0.0 to connect to SQL Server.