How to update Bulk records using Update query in Sql Server ?

Question

Hi Team, Is there any way we can update 1 Million records using Update query in Sql Server, Can you please share me any link for references. Thanks!

Khaja Moizuddin · Answer

Hello Geetha, Thanks for the reply, will i be able to update to Millions of records with the steps you provided.

geetha geetha · Answer

We have to update the bulk record using stored procedure and user define types. at first we have to create a data base after that create table for that database. after creating the table you need to create a user define table type for employee table, which is is a custom user defined table type which will contain data in tabular format. We use these datatypes for pass the table value parameter in stored procedure. You also create a user define table type in programmability -> Types -> User defined table types. after that you have to create a stored procedure for performing the update operation and also perform insert operation, Here I used merge feature, it will perform insert and update operation in same query. Here after I have to create a variable of User defined table type to pass it as parameter of procedure.You need to insert some value, finally execute the stored procedure. We can update the bulk data using stored procedure.

Tanuj Gyan · Answer

I am not sure if you have already tried this, but it looks similar to what you are asking for https://www.codeproject.com/Questions/1197214/How-to-do-bulk-update-in-SQL-server-in-single-upda

Aishwarya · Answer

Try this below Query: UPDATE TABLE_NAME SET COLUMN_VALUE = CASE COLUMN_NAME WHEN 'COLUMN_NAME1' THEN COLUMN_VALUE1 WHEN 'COLUMN_NAME2' THEN COLUMN_VALUE2 ELSE COLUMN_VALUE END WHERE COLUMN_NAME IN('COLUMN_NAME1', 'COLUMN_NAME2');