怎样在存储过程里判断Select语句是否有符合记录返回？

[michael_jian]

怎样在存储过程里判断Select语句是否有返回记录？

[CityhunterID]

SET NOCOUNT ON

SELECT * ……


IF (@@rowcount >1 )
RETURN 0
ELSE
RETURN 1

[lihonggen0]

create proc spAddCusVarQuanDsp (
@CusConsultID int,
@GenDate datetime,
@Notes varchar(200),
@ID int output
)
as
insert into CusVarQuanDsp(
CusConsultID ,
GenDate ,
Notes
)
values(
@CusConsultID ,
@GenDate ,
@Notes
)
Select @ID = Max(ID) from CusVarQuanDsp '将这个值传出

GO

'你可以用select 语句，找到符合条件记录数，将记录数传递

[swpisun]

If (select count(*) from ... ) > 0
begin
print 'it exist'
end

[online]

CREATE PROCEDURE test(@dwbh CHAR(7)) AS
--给要返回值起个别名就可以了
select dwbh as s1,dwsj as s2,dwzt as s3 from dwjbda where dwbh=@dwbh
下面是vb的过程
private sub refreshlist()
dim rs as recordset
set rs=mconn.execute("test",,adcmdstoredproc)
txt.text=rs("s1")
end sub