aiswarjya sarengi

aiswarjya sarengi

  • NA
  • 271
  • 8.7k

insert and update query

Jul 12 2017 7:52 AM
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

Answers (2)