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

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


.改为,