我试图实现简单的任务:从表的2列中选择值。
如果值之一为null,则返回null或其他值。
否则返回值。
SELECT
MobileAreaCode, Mobile
FROM
TABLE_NAME
WHERE
id = 123456789
IF (MobileAreaCode is NULL OR Mobile is NULL)
BEGIN
RETURN(1)--NULL
END
ELSE
BEGIN
RETURN(MobileAreaCode+Mobile)
END
帮助将不胜感激
根据您对我的评论,这是您想要的:
ALTER PROCEDURE PRO_NAME (Identification INT)
AS SELECT
CASE WHEN CONVERT(MobileAreaCode, int)>1 OR
CONVERT(Mobile, int)>1 THEN MobileAreaCode+Mobile
End FROM TABLE_NAME WHERE Hp=(Identification)
GO
较旧的想法/信息..尝试一下..
SET NOCOUNT ON
SELECT
CASE WHEN MobileAreaCode is NOT NULL OR Mobile is NOT NULL THEN
MobileAreaCode+Mobile
END
FROM
TABLE_NAME
WHERE
id = 123456789
其它的办法..
SET NOCOUNT ON
SELECT
CASE WHEN CONVERT(MobileAreaCode, int)>1 OR CONVERT(Mobile, int)>1 THEN MobileAreaCode+Mobile End
END
FROM
TABLE_NAME
WHERE
id = 123456789
使用ISNULL ..
SET NOCOUNT ON
SELECT
CASE WHEN NOT ISNULL(MobileAreaCode, 000) OR NOT ISNULL(Mobile, 000) THEN MobileAreaCode+Mobile End
END
FROM
TABLE_NAME
WHERE
id = 123456789
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句