How to move the responsibility of executing some logic to the SQL Server instead of executing that logic inside the application?

How to move the responsibility of executing some logic to the SQL Server instead of executing that logic inside the application?katarina zed

How to move the responsibility of...

I have an Excel file that contains many columns like this :

SKU BarCode EnglishName ArabicName Category SubCategory

The problem: the data of that Excel file should be persisted into the appropriate tables in a SQL Server database which does not merely contain a single table, so specific data from…