Updating multiple columns using Microsoft SQL Server

Question

I am trying to write an SQL script where I can replace data in multiple columns, see below:

SQL Script:

UPDATE SohailsTest.dbo.OBJECT
SET VARIABLE = REPLACE(VARIABLE, 'C:\', 'E:\')
SET STATIC = REPLACE(STATIC, 'C:\', 'E:\');

I have tried the above, but it says:

Error Message:

Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '='.

What am I doing wrong?

SET VARIABLE = REPLACE(VARIABLE, 'C:\', 'E:\'), STATIC = REPLACE(STATIC, 'C:\', 'E:\'); — Giorgi Nakeuri
– Giorgi Nakeuri, Commented Dec 7, 2015 at 15:25

Lamak · Accepted Answer · 2015-12-07 15:25:18Z

5

You need to use only one SET:

UPDATE SohailsTest.dbo.OBJECT
SET [VARIABLE] = REPLACE([VARIABLE], 'C:\', 'E:\'),
    [STATIC] = REPLACE([STATIC], 'C:\', 'E:\');

answered Dec 7, 2015 at 15:25

Lamak

70.8k12 gold badges118 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zedfoxus · Accepted Answer · 2015-12-07 15:25:27Z

3

Try this:

UPDATE SohailsTest.dbo.OBJECT
SET VARIABLE = REPLACE(VARIABLE, 'C:\', 'E:\'), STATIC = REPLACE(STATIC, 'C:\', 'E:\');

answered Dec 7, 2015 at 15:25

zedfoxus

37.4k5 gold badges68 silver badges66 bronze badges