我很惭愧,问这么简单的问题!!!!!!!!!!!!!!!!!
CREATE PROCEDURE BuyMessage
(
@recordid INT,
@buyid INT,
@sorb INT,
@sellid INT OUTPUT,
@result INT OUT
)
AS
if @sorb=0
SELECT @sellid=BuyId
FROM BuyM_View
WHERE RecordId=@recordid AND SellId=@buyid
else if @sorb=1
SELECT @sellid=SellId
FROM SellM_View
WHERE RecordId=@recordid AND BuyId=@buyid
IF @@ROWCOUNT >= 1
SELECT @result=1
ELSE
SELECT @result=0
GO
====================================================
以上存储过程的IF @@ROWCOUNT >= 1,我想用他来检查上面的语句是否执行过,执行过则令@result=1,否则@result=0.但是不知道怎么的每次我测试他都是@result=0.不知道何故?是不是IF @@ROWCOUNT >= 1的问题呢?注意上面用到了if else if的判断