insert and update query

Question

CompanyID Year TurnOver OperationalEmpStrength MarketingEmpStrength FinanceEmpStrength OtherEmpStrength 2 2015 25 58 25 36 3 2 2015 25 58 25 36 3 2 2017 25 0 25 36 3 2 2016 0 0 24 0 0 i insert these value together using a loop(C#) and a insert query(store procedure) if i want to update any of them what is the procedure

Puneet Kankar · Answer

Refer to this link https://www.aspsnippets.com/Articles/SqlBulkCopy--Bulk-Insert-records-and-Update-existing-rows-if-record-exists-using-C-and-VBNet.aspx https://stackoverflow.com/questions/20635796/bulk-update-in-c-sharp

Ibrahim Siddique · Answer

INSERT INTO table (id Year TurnOverOperationalEmpStrengthMarketingEmpStrengthFinanceEmpStrengthOtherEmp) VALUES(1 A 19) ON DUPLICATE KEY UPDATE Year=@Year TurnOver=@TurnOver OperationalEmpStrength=@OperationalEmpStrength MarketingEmpStrength=@MarketingEmpStrength FinanceEmpStrength=FinanceEmpStrength@ OtherEmp=@OtherEmp

CompanyID	Year	TurnOver	OperationalEmpStrength	MarketingEmpStrength	FinanceEmpStrength	OtherEmpStrength
2	2015	25	58	25	36	3
2	2015	25	58	25	36	3
2	2017	25	0	25	36	3
2	2016	0	0	24	0	0