sql server分批更新数据(类似mysql limit)

 

create table hxl_employees (
    employeeid int primary key,
    firstname varchar(50),
    lastname varchar(50),
);

insert into hxl_employees(employeeid,firstname) values(1,'name1');
insert into hxl_employees(employeeid,firstname) values(2,'name2');
insert into hxl_employees(employeeid,firstname) values(3,'name3');
insert into hxl_employees(employeeid,firstname) values(4,'name4');
insert into hxl_employees(employeeid,firstname) values(5,'name5');
insert into hxl_employees(employeeid,firstname) values(6,'name6');
insert into hxl_employees(employeeid,firstname) values(7,'name7');
insert into hxl_employees(employeeid,firstname) values(8,'name8');
insert into hxl_employees(employeeid,firstname) values(9,'name9');
insert into hxl_employees(employeeid,firstname) values(10,'name10');


update top(2) hxl_employees
set lastname='name2'
where lastname is null