怎么把结果集放在一个字段里保存

如何把结果集放在一个字段里保存
DECLARE @arrChildID NVARCHAR(50) 
select arrChildID= nodeid from nodes where ParentID=1

结果：
  arrChildID
1 12
2 15
3 18
4 20
5 25

问：把结果集放在一个字段里保存
update .........set A='12,15,18,20,25'



[解决办法]

SQL code

DECLARE @arrChildID NVARCHAR(50)  select @arrChildID=isnull(@arrChildID+','.'')+nodeid from nodes where ParentID=1select @arrChildID
[解决办法]
DECLARE @arrChildID NVARCHAR(50) 
select @arrChildID =rtrim(nodeid)+','+@arrChildID  from nodes where ParentID=1
update .........set A=@arrChildID
[解决办法]
探讨


SQL code
DECLARE @arrChildID NVARCHAR(50)  
select @arrChildID=isnull(@arrChildID+','.'')+nodeid from nodes where ParentID=1
select @arrChildID

[解决办法]
这个可能跟你原表情况类似一些
SQL code
create table nodes( nodeid varchar(10))insert into nodesselect '12' union allselect '15' union allselect '18' union allselect '20' union allselect '25'declare @arrChildID varchar(500)select @arrChildID=isnull(@arrChildID+',','')+nodeid from nodesselect  @arrChildIDupdate  updated_tb set updated_col=@arrChildID
[解决办法]
探讨


引用:

SQL code
DECLARE @arrChildID NVARCHAR(50)
select @arrChildID=isnull(@arrChildID+','.'')+nodeid from nodes where ParentID=1
select @arrChildID


.改为,