34,588
社区成员
发帖
与我相关
我的任务
分享
if object_id('tempdb.dbo.#') is not null drop table #
create table # (id int, name varchar(20))
insert # select 1000,'李四'
insert # select 2000,'张三'
insert # select 2000,'张三'
insert # select 2000,'张三'
insert # select 2000,'张三'
insert # select 2000,'张三'
--> 2005 可以这样删
delete top(4) from # where id = 2000 and name = '张三'
select * from #
/*
id name
----------- --------------------
1000 李四
2000 张三
*/
delete from LMS.dbo.ces where id = '2000' and name '张三'
insert into LMS.dbo.ces values('2000','张三')