DECLARE @b_overlap bit set @b_overlap=0 --初始为不重复 IF EXISTS (SELECT 重复判断的字段 FROM 表 GROUP BY 重复判断的字段 HAVING COUNT(*) > 1) begin set @b_overlap=1 --设置为有重复 end if @b_overlap=1 begin print '有重复记录' end else begin print '无重复记录' end
it's not easy to fulfill with a single sql line,I think.
vfp: select 200-200 as jlh,* from tablename into table linsi sele linsi repl jlh with recno() all select jlh from linsi group by jlh having count(*)>=2 sql server: 没有记录号的概念。把编号字段给取出来。 select bh from tablename group bu bh having count(bh)>=2
set @b_overlap=0 --初始为不重复
IF EXISTS (SELECT 重复判断的字段 FROM 表 GROUP BY 重复判断的字段 HAVING COUNT(*) > 1)
begin
set @b_overlap=1 --设置为有重复
end
if @b_overlap=1
begin
print '有重复记录'
end
else
begin
print '无重复记录'
end
你按他们说的那样先找出重复的数据记录到一个新表,再把这个新表与你要更新的表建立关联,来更新你这个表,自己试试吧
select 200-200 as jlh,* from tablename into table linsi
sele linsi
repl jlh with recno() all
select jlh from linsi group by jlh having count(*)>=2 sql server:
没有记录号的概念。把编号字段给取出来。
select bh from tablename group bu bh having count(bh)>=2