sql - Update all columns in one row (adding xxx-xxx to beginning of every row) -

sql - Update all columns in one row (adding xxx-xxx to beginning of every row) -

i have update column userid adding domain-name\ every user in rows. saw how remove in 1 row

update employee set emp_name = replace(emp_name, 'xx\', '')

but how do in reverse?

query:

sqlfiddleexample

update employee set userid = 'domain-name\' + userid

result:

| id | type | userid | -------------------------------------------------- | 1 | email | domain-name\admin@sqlfiddle.com | | 2 | twitter | domain-name\@sqlfiddle |

sql sql-server