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

Khaja Moizuddin

4y1.4k

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!

4 Replies

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

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');

Khaja Moizuddin4y ago
Hello Geetha, Thanks for the reply, will i be able to update to Millions of records with the steps you provided.
+2
geetha geetha4y ago
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.
+1
Tanuj Gyan4y ago
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
+2