阅读背景:

在where子句中不能使用临时列?

来源:互联网 
select  cast(de.ApprovalOrder AS VARCHAR(32)) 
            + cast(de.EntityCode AS VARCHAR(32)) 
            + isnull(cast(de.DelegationCode AS VARCHAR(32)), '') as 'RowID' ,
            *
from    workflow.delegation_engine de
where   RowID <> NULL
select  cast(de.ApprovalOrder AS VARCHAR(32)) 



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: