declare @cz int
set @cz=0
select @cz=count(*) from kh group by dwbh having(count(dwbh)>1)
if @cz>0 goto error0 --这里的实际结果是@cz=0,但是sql仍然给我跳转到了error0那里?怎么回事?
error0:
print 'dwbh重复'
return
set @cz=0
select @cz=count(*) from kh group by dwbh having(count(dwbh)>1)
if @cz>0 goto error0 --这里的实际结果是@cz=0,但是sql仍然给我跳转到了error0那里?怎么回事?
error0:
print 'dwbh重复'
return
declare @cz int
set @cz=0
select @cz=0--count(*) from kh group by dwbh having(count(dwbh)>1)
if @cz>0 goto error0 --这里的实际结果是@cz=0,但是sql仍然给我跳转到了error0那里?怎么回事?
else goto noerrorerror0:
print 'dwbh重复'
noerror:
print 'right'
--return
--其实可以这样处理,不到万不得已,不建议用goto
declare @cz int
set @cz=0
select @cz=count(*) from kh group by dwbh having(count(dwbh)>1)
if @cz>0 print 'dwbh重复'
return
要么你在error0: 前加return
要么
declare @cz int
set @cz=0
select @cz=count(*) from A group by dwbh having(count(dwbh)>1)
if @cz>0 goto error0 --这里的实际结果是@cz=0,但是sql仍然给我跳转到了error0那里?怎么回事? else goto e1--加
error0:
print 'dwbh重复'
returne1:--加