Update With Select

CREATE TABLE A1 (
        SN NUMERIC(3,0) IDENTITY,
        NAME VARCHAR(20) NULL,
        ADDRESS VARCHAR(50) NULL,
        CONSTRAINT A1_PK PRIMARY KEY (SN)
);

--INSERT INTO A1 (NAME,ADDRESS) VALUES ('曾先生', '台北市');
--INSERT INTO A1 (NAME,ADDRESS) VALUES ('曾小姐', '台南市');
--INSERT INTO A1 (NAME,ADDRESS) VALUES ('王學生', '台西市');
--INSERT INTO A1 (NAME,ADDRESS) VALUES ('韋日歷', '台東市');
--INSERT INTO A1 (NAME,ADDRESS) VALUES ('本著心', '新北市');
--INSERT INTO A1 (NAME,ADDRESS) VALUES ('照著唸', '新竹市');

UPDATE A1 
SET NAME=A1_TEMP.NAME, ADDRESS='LALALA'
FROM A1,A1 A1_TEMP
WHERE A1.SN=3 AND A1_TEMP.SN=1;