SQL判断如果一列值为null则取另一列值代替 isnull()
时间:2014-11-24 18:40:02
收藏:0
阅读:510
SELECT TOP 1000 [chClientCode] ,[nvcClientName] ,[chRegionCode] ,isnull(chUltimateHeadClientCode,[chClientCode]) as chUltimateHeadClientCode FROM [PwCMDM_V1].[Core].[tblClient]
Define:
isnull(expression,replacement_value)
原文:http://www.cnblogs.com/dangkei/p/4119052.html
评论(0)