摘要:
--创建测试表create table dbo.t1(c int identity(1,1) not null,name varchar(10) null)insert into dbo.t1 values('guoqiang')select * from t1--删除前3行select top(3) * from dbo.t1delete top(3) from dbo.t1--删除重复记录declare @count intselect @count =count(*) from dbo.t1 where name = 'guoqiang'delete to 阅读全文