34,838
社区成员




CREATE VIEW XXX
AS
SELECT
a.x=case when b.y!='' then b.y else (case when c.z!='' then c.z end) end,
其他字段
FROM xxxx
WHERE 条件
CREATE VIEW XXX
AS
SELECT
a.x=case when b.y!='' else (case when c.z!='' then c.z end) end,
其他字段
FROM xxxx
WHERE 条件
a.x=CASE WHEN isnull(b.y,'')<>'' THEN b.y ELSE CASE WHEN ISNULL(c.z,'')<>'' THEN c.z ELSE a.x END END
a.x=case when b.y!='' else (case when c.z!='' then c.z end) end