sql server 使用存储过程将一列值拼成字符串

create PROCEDURE UP_GETVALUE AS DECLARE @value VARCHAR(100), @tmp VARCHAR(100) declare cursorA cursor for select KEYWORDS FROM (SELECT '牛仔服' AS KEYWORDS UNION ALL SELECT '毛皮' UNION ALL SELECT '医药') AS aaopen cursorAfetch next f