摘要: --创建测试表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 阅读全文
posted @ 2008-07-25 09:43 深潭 阅读(283) 评论(0) 推荐(0) 编辑