DECLARE @A INT
SELECT @A = (SELECT a FROM A WHERE b = '0 ')
IF (@A = NULL)--这个地方不能用isnull(@A, '替换成别的 ')来处理。
PRINT 1
ELSE
PRINT 0
[email protected]?
------解决方案--------------------
DECLARE @A INT
SELECT @A = (SELECT a FROM A WHERE b = '0 ')
IF (@A IS NULL)
PRINT 1
ELSE
PRINT 0
------解决方案--------------------
@A is NULL