34,576
社区成员
发帖
与我相关
我的任务
分享
select * from tableName
id name
1 张三
2 李四
3 王五
4 赵六
5 田七
UDPATE tableName set name='小明' where id=1
select top 3 Fid,Fdate from HR_ATS_EmpRoster order by fid
BEGIN TRANSACTION
Begin
select top 3 Fid,Fdate from HR_ATS_EmpRoster order by fid
update HR_ATS_EmpRoster set Fdate='2012-02-19' where Fid=1
COMMIT
end
select top 3 Fid,Fdate from HR_ATS_EmpRoster order by fid
Fid Fdate
----------- -----------------------
1 2012-02-25 00:00:00.000
2 2010-01-01 00:00:00.000
3 2010-01-01 00:00:00.000
(3 行受影响)
Fid Fdate
----------- -----------------------
1 2012-02-25 00:00:00.000
2 2010-01-01 00:00:00.000
3 2010-01-01 00:00:00.000
(3 行受影响)
(1 行受影响)
Fid Fdate
----------- -----------------------
1 2012-02-19 00:00:00.000
2 2010-01-01 00:00:00.000
3 2010-01-01 00:00:00.000
(3 行受影响)