在存储过程中如何根据 SELECT COUNT(*) 的值来做判断：
DECLARE @CountID int
SELECT COUNT(*) AS @CountID FROM Accounts_Comments WHERE UserID = @UserID
IF @CountID=0
ELSE
这样好像不行，能用：
SET @CountID = (SELECT COUNT(*) AS @CountID FROM Accounts_Comments WHERE UserID = @UserID〗
IF @CountID=0
ELSE
求一个解答。
------解决方案--------------------
- SQL code
DECLARE @CountID int SELECT @CountID=COUNT(*) FROM Accounts_Comments WHERE UserID = @UserID IF @CountID=0 ELSE
------解决方案--------------------
- SQL code
IF (SELECT COUNT(1) FROM Accounts_Comments WHERE UserID = @UserID)=0 PRINT 'No Data for [email protected]else...
------解决方案--------------------
- SQL code
--日，这个地方count(*)要改，不然会一直存在一条记录，忘记改了IF not exists (select 1 from Accounts_Comments WHERE UserID = @UserID) ELSE