1
Answer

How to bulk update an sql server table using xml ?

Vikas Gupta

Vikas Gupta
6y
595
1
  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)
Next Recommended Forum