请问，在SQL SERVER2000中编写存储过程，

[Nickcour]

请问，在SQL SERVER2000中编写存储过程，
如下
CREATE PROCEDURE King.FindIP (@dt datetime,@re bit output) as
select * from NOIP where dates >@dt
GO
请问，如何断判select语句中，有没有找到记录

[CrazyFor]

CREATE PROCEDURE King.FindIP (@dt datetime,@re bit output) as
if (select count(*) from NOIP where dates >@dt)>0
print '有'
else
print '无'
GO

[lang_ren]

CREATE PROCEDURE King.FindIP (@dt datetime,@re bit output) as
begin
select @re=0
select *,@re=1 from NOIP where dates >@dt
end
GO

[angle1219]

在select 语句后加
if @@rowcount>0
print '有'
else
print '没有'

[pengdali]

CREATE PROCEDURE King.FindIP (@dt datetime,@re bit output) as
select * from NOIP where dates >@dt
if @@rowcount>0
set @re=1 --有
else
set @re=0 --无
GO
或：
CREATE PROCEDURE King.FindIP (@dt datetime,@re bit output) as
if exists(select 1 from NOIP where dates >@dt)
set @re=1 --有
else
set @re=0 --无
GO

[xpilot]

CREATE PROCEDURE King.FindIP (@dt datetime,@re bit output) as
If not exists (select * from NOIP where dates >@dt)
Begin
Select @re = 1
Print 'No record!'
Return
End
GO

[ShapeRock]

@@RowCount是判断上一条SQL语句的影响行数。