update tbname
set name='abc' --name原来的值就是abc
where id=1
再如:
update tbname
set name='abc' --name原来的值就是abc
where name='abc'
接下来我们将实际测试:
--Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2)
CREATE DATABASE DB_test
GO
USE DB_test
GO
CREATE TABLE t (
a INT,
b CHAR(1),
CONSTRAINT PK_t PRIMARY KEY CLUSTERED (a)
);
INSERT INTO t VALUES (1,'A');
INSERT INTO t VALUES (2,'B');
INSERT INTO t VALUES (3,'C');
INSERT INTO t VALUES (4,'D');
INSERT INTO t VALUES (5,'E');
CHECKPOINT;
3.查看事务日志