Please can someone assist,
I've ran the following command which has been working ok.
INSERT INTO tbUser (UserName,UserLogin,UserGroupId)
VALUES ('TestPaul','domain\tuser',9);
Now I need to update the 'userGroupid only' to another number for this specific user 'TestPaul' e.g from 9 needs changing to 44.
How do I go about this, I tried changing INSERT INTO to UPDATE but the syntax is not correct?