SQL Update help needed

Moley · 19 Mar 2012 at 18:12

This is one for the dbo's out there...

I have an MSSQL database with a table in it dbo.useraccounts that has a field 'name' that is current populated with real users names. I need to anonymise all these entries into 'DOMAIN\User1', 'DOMAIN\User2', etc

Does anyone know a bit of sql I can run to achieve this?

Many thanks!

:cool:

RobH · 19 Mar 2012 at 18:38

Does the table have an id field?

If so you could do something like this:

Code:

UPDATE dbo.useraccounts
  SET useraccounts.name = CONCAT('DOMAIN\User', useraccounts.id)

Note, this is MySQL Syntax, MSSQL may be different.

Ciphon · 19 Mar 2012 at 19:40

So you want to add "DOMAIN\" to the front of the existing cell contents? If so, the below would do it..

UPDATE dbo.useraccounts
SET name = 'DOMAIN\' + name

Moley · 19 Mar 2012 at 21:52

Thankyou for your help guys - this statement did the trick:

update Anonymous.dbo.useraccounts
set name = 'DOMAIN\User' + cast(useraccounts.id as varchar(3))

Again - many thanks!