Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

How to bulk update an sql server table using xml ?

Home
Forums

How to bulk update an sql server table using xml ?

Vikas Gupta

Vikas Gupta

8yAsked Jun 22, 2018, 1:50 AM846

SELECT transId ,
rollNo ,
Answer ,
CorrectAns , --update
WrongAns --update
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?

1 Reply

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

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Nanddeep Nachan8y ago
Read from xml in temp SQL table
DECLARE @input XML = '

  name="NAME_LAST" type="xs:string" length="62" />
  name="NAME_FIRST" type="xs:string" length="62" />
  name="NAME_MIDDLE" type="xs:string" length="32" />



SMITH
MARY
N


SMITH2
MARY2
N2


'

INSERT INTO #TempTable(ColName, ColFirstName, ColOther)
   SELECT
      Name = XCol.value('(value)[1]','varchar(25)'),
      FirstName = XCol.value('(value)[2]','varchar(25)'),
      OtherValue = XCol.value('(value)[3]','varchar(25)')
   FROM
      @input.nodes('/dataset/data/row') AS XTbl(XCol)
Update from temp table using primary key
Update MyTable
  Set Field1 = tt.Field1,
      Field2 = tt.Field2,
      ...
FROM #TempTable tt
where primaryKey = tt.PrimaryKey
+1