I know this is an old thread, but: UPDATE rdbms SET @Old_Pname = PName, PName = 'SQL Server' where ID = 1 or even: UPDATE rdbms SET @Old_Pname =...
Separate names with a comma.