Vikas Gupta

Vikas Gupta

  • NA
  • 118
  • 7k

How to bulk update an sql server table using xml ?

Jun 22 2018 1:50 AM
  1. SELECT transId ,  
  2. rollNo ,  
  3. Answer ,  
  4. CorrectAns , --update  
  5. WrongAns --update  
  6. FROM dbo.T_OMR_ScanningData  
i have a list of students with transid,rollNo and Answer. I want to update all students CorrectAns and WrongAns at a time using XML.
 
Is it possible to do like so?

Answers (1)