以下是将X++代码转换为SQL Server代码的结果:

SELECT TOP 1 securityUserRole.*
FROM securityUserRole
INNER JOIN securityRole ON securityRole.recId = securityUserRole.SecurityRole
WHERE securityUserRole.[User] = curUserId()
AND (securityRole.AotName = '#IdcfRoleAotName_SYSADMIN'
    OR securityRole.AotName = '#IdcfRoleAotName_IDCFACCOUNTINGSTAFF'
    OR securityRole.AotName = '#IdcfRoleAotName_IDCFHEADOFFICEACCOUNTINGSTAFF'
    OR securityRole.AotName = '#IdcfRoleAotName_IDCFPURCHDEPARTMENTBUYER');
把以下X++ sql代码转换成sqlserver代码:select firstonly securityUserRole where securityUserRoleUser == curUserId join securityRole where security

原文地址: https://www.cveoy.top/t/topic/i87j 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录