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.

update 180k records

Home
Forums
SQL

update 180k records

jayu p

5yAsked Jun 27, 2021, 8:53 PM796SQL

I would like to know better solution to update 180K records in one table from another in sql

no performance issue, it should be faster.

mostly like first update 500 records wait for 1 min then update next 500 till I reach my no fo records present in table

3 Replies

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

Sachin Singh5y ago
Accepted answer
this is how you can update in batches
DBCC DROPCLEANBUFFERS

DECLARE @id_control INT
DECLARE @batchSize INT
DECLARE @results INT

SET @results = 1
SET @batchSize = 10000
SET @id_control = 0

WHILE (@results > 0)
BEGIN
   -- put your custom code here
   BEGIN TRAN;

update Table1
set col1= t2.col1, and so on
from Table1 t1
inner join Table2 t2
on t1.ID = t2.ID

   WHERE  t1.ID > @id_control
   AND t1.ID <= @id_control + @batchSize

   -- very important to obtain the latest rowcount to avoid infinite loops
   SET @results = @@ROWCOUNT
   -- next batch
   SET @id_control = @id_control + @batchSize
END

   COMMIT TRAN;
jayu p5y ago
@sachin: could you please help me with cursor?
Jignesh Kumar5y ago
Hi,

You can use bulk update in Store Procedure,
https://www.c-sharpcorner.com/article/sql-bulk-insert-and-update-records-using-stored-procedures/
https://www.aspsnippets.com/Articles/SqlBulkCopy--Bulk-Insert-records-and-Update-existing-rows-if-record-exists-using-C-and-VBNet.aspx