同一字段可以存入多个值(就是多选项,但是保存到数据库要求分开保存,回显要求合并回显),
数据库查询就合并多选字段!!!
SELECT
DISTINCT
[fieldName] = stuff(
(
SELECT
',' + t.fieldName
FROM
CostCalculationRelation t
WHERE
t.partNumber = td.partNumber
AND t.costFieldName = td.costFieldName
FOR xml path ('')
),
1,
1,
''
),
td.partNumber,td.costFieldName
FROM
CostCalculationRelation td
GROUP BY
td.partNumber,td.costFieldName,td.fieldName
判断为空的函数,(判断为空就返回空,否则返回DictName)
isnull(DictName,"") as eventType;