Pooja Chowdhury

Pooja Chowdhury

  • NA
  • 396
  • 39.3k

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)