1.isnull替换 select keyId,isnull(info,‘替换null值’) as info from test go 2.case when 替换 CASE WHEN org2.orgshortname IS NOT NULL THEN org2.orgshortname ELSE org3.orgshortname END as INSORGNAME, 3.coalesce替换 coalesce(iam.invoiceno ,'-') as COUNTNO, 希望所写的对你们有用。