如何将4列数据合并成一列？

Question

在SQL 2008中，我试图将来自4列的数据合并到一个列中。我搜索并尝试了几件不同的事情，但没有一件奏效。我最近的尝试是：

SELECT [2012 Notes] + [2012 STEPS TAKEN TO REMEDY ISSUES] + [2013 NOTES] + [2013 STEPS TAKEN TO REMEDY ISSUES] AS 'ConcatNotes'
FROM ECRSurvey

UPDATE ECRSurvey Set UserNotes = 'ConcatNotes'

但这不起作用。有人能告诉我该怎么做吗？我基本上试着获取4列，并尝试将这些数据合并到UserNotes字段中。

Answer 1

这应该管用-你可能有一些零线。

试一试

SELECT ISNULL([2012 Notes],'') + ISNULL([2012 STEPS TAKEN TO REMEDY ISSUES],'') + ISNULL([2013 NOTES],'') + ISNULL([2013 STEPS TAKEN TO REMEDY ISSUES],'') AS 'ConcatNotes'
FROM ECRSurvey

或更新

UPDATE ECRSurvey Set UserNotes = ISNULL([2012 Notes],'') + ISNULL([2012 STEPS TAKEN TO REMEDY ISSUES],'') + ISNULL([2013 NOTES],'') + ISNULL([2013 STEPS TAKEN TO REMEDY ISSUES],'')

Answer 2

如果这些列中有任何一个包含NULL，结果将为NULL。您将希望合并或对字段进行isnull检查。

Answer 3

请尝试以下查询：

Update ECRSurvey
set UserNotes =[2012 Notes] + [2012 STEPS TAKEN TO REMEDY ISSUES] + [2013 NOTES] + [2013 STEPS TAKEN TO REMEDY ISSUES]