编写函数的时候遇到“不允许 ASSIGNMENT 语句中包含 FOR XML 子句”错误,开始以为数据库函数里不可以写 FOR XML 子句,仔细看了看总觉得这么写别扭索性改了一种写法就通过了。
BEGIN
SELECT @Values = ValueCode + ','
FROM Product
WHERE Code = @Code AND SortIndex = @Sort FOR XML PATH('');
END
解决办法:
BEGIN
SET @Values = (SELECT ValueCode
FROM Product
WHERE Code = @Code AND SortIndex = @Sort FOR XML PATH(''));
END