sql 根据客户需用 调价查询字段
标签：字段 log end color ant field custom pre code
sql 根据客户需用 调价查询字段
@vcFieldName VARCHAR(100)= ‘nMerchantId,nUserId,dmMoney‘
SELECT nMerchantId, nUserId, dmMoney, CASE WHEN CHARINDEX(‘nMerchantId‘, @vcFieldName) > 0 THEN nMerchantId
ELSE 0
END + CASE WHEN CHARINDEX(‘nUserId‘, @vcFieldName) > 0 THEN nUserId
ELSE 0
END + CASE WHEN CHARINDEX(‘dmMoney‘, @vcFieldName) > 0 THEN dmMoney
ELSE 0
END AS dmTotal
FROM GM.CRM_Customer