select t1.* from classmate as t1,(select fname ,count(*) as num from classmate group by fname )as t2 where num>1 可以找出在classmate表中重复的记录
if exists(select 1 from classmate where fname=@name) begin set @errmsg =0 raiserror('请输入新的名字!!',16,1) end else insert classmate (fname,sex,address,telphone,grade,objects) values (@name,@sex,@address,@phone,@grade,@object)
漏了一句 :where num>1 and t1.fname=t2.fname
或者先建一个视图view1: select fname ,count(*) from classmate group by fname having count(*)>1然后:select * from classmate where fname in (select fname from view1) 同样可以查出重复的记录
group by fname )as t2
where num>1
可以找出在classmate表中重复的记录
begin
set @errmsg =0
raiserror('请输入新的名字!!',16,1)
end
else
insert classmate (fname,sex,address,telphone,grade,objects)
values (@name,@sex,@address,@phone,@grade,@object)
:where num>1 and t1.fname=t2.fname
select fname ,count(*)
from classmate
group by fname
having count(*)>1然后:select * from classmate
where fname in (select fname from view1)
同样可以查出重复的记录