SQL Update in place
Update in place
USE pubs
GO
if exists (SELECT * FROM sysobjects where name='T1' and type='U')
DROP TABLE T1
GO
CREATE TABLE T1(X int primary key, Y int)
INSERT T1 VALUES(1, 10)
INSERT T1 VALUES(2, 20)
GO
UPDATE T1 SET X = 3 - X
GO