SQL server 2005 表中某一字段的所有值逗号分开的列表

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

--SQL server 2005 表中某一字段的所有值逗号分开的列表Geovin Du 塗聚文 select * from Production.Product   declare @names varchar(50) set @names='' select @names=@names+s.Name+' , ' from Production.Product s order by s.Name   select @names go --sql server 2000 如何逐条读出表中某一字段的所有值 Geovin Du 塗聚文 declare @allstring varchar(8000) set @allstring='' select @allstring=@allstring+convert(varchar(10),PublicHolidayID)+';' from PublicHolidayRest print @allstring GO

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14

--查询字符中包函的结果 declare @sql varchar(500),@in varchar(500),@where varchar(800),@allstring varchar(8000) set @sql='select * from intranet.dbo.v_lc ' set @allstring=''   select @allstring=@allstring+''''+BranchNO+''''+',' from  intranet.dbo.v_lc  where ServiceCardNo='008888' set @allstring=left(@allstring,len(@allstring)-1) set @where=@allstring set @in=' where  BranchNO in ('+@where+')' set @sql=@sql+@in print @sql print @allstring exec (@sql) GO