Get User CustomNotificationAddresses

select pv.StringValue, * from tbl_Identity    i
left join tbl_PropertyValue pv on pv.ArtifactId=convert(binary(16),i.id)
--where i.AccountName='danzhang'
and pv.PropertyId=32

select * from tbl_PropertyDefinition

select pd.Name, * from tbl_PropertyValue pv left join tbl_PropertyDefinition pd on pv.PropertyId=pd.PropertyId
where pv.StringValue='zhanghongjun@bjgreatsoft.com'

原文地址:https://www.cnblogs.com/danzhang/p/7486374.html