Loading

insert and update query

Pooja Chowdhury

9y850

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ibrahim Siddique9y ago

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

0

Puneet Kankar9y ago
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
0