Ò»¸ösql Óï¾ä..... - .NET¼¼Êõ / ASP.NET

@ResultMessage £ºÊä³ö²ÎÊý
 @ResultMessage varchar(100) output

 if((select count(*) from dbo.tb_readerInfo where readerId=@readerId and haveBorrowNum<canBorrowNum)=0) 
 @ResultMessage = '¸Ã¶ÁÕß²»´æÔÚ»òÕß½èÔÄÊé¼®ÒÑÂú'

ÎÒÏëÔÚ´æ´¢¹ý³ÌÀïÃæ¸ø @ResultMessage¸³ÖµÎªÒ»¸ö×Ö·û´® 
ΪʲôÉÏÃæµÄÊÇ´íµÄÄØ £¿ ¸ÃÔõÑùд.....???

лÁË£¡

---

end if

---

¿É²»¿ÉÒÔ˵Ïêϸһµã°¡, СµÜ°ÝлÁË......

---

SQL code:

@ResultMessage varchar(100) output
as
begin
if((select count(*) from dbo.tb_readerInfo where readerId=@readerId and haveBorrowNum<canBorrowNum)=0)
@ResultMessage = '¸Ã¶ÁÕß²»´æÔÚ»òÕß½èÔÄÊé¼®ÒÑÂú'
end

---

»¹ÊDz»Ðа¡, ÏÂÃæÊÇÈ«²¿µÄÓï¾ä......  
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  
-- Create date: 
 -- Description:
-- =============================================
CREATE PROCEDURE ProBookBorrowInsert
 @readerId int,
 @bookId int,
 @returnTime datetime,
 @ResultMessage varchar(100) output
AS
BEGIN  
 
  if((select count(*) from dbo.tb_readerInfo where readerId=@readerId and haveBorrowNum<canBorrowNum)=0) 
  @Res