SQL 把结果集的某列连加成一行

 DECLARE @RESULT NVARCHAR(MAX);
 SELECT  @RESULT =ISNULL(@RESULT,'') + ISNULL(LookupKey,'')+',' FROM tblCtcLookup WHERE LookupCat='AppSettings'
 SELECT  @RESULT