SQL-将表中一个字段的列转化成一个字符串
发表于 2014-04-19
declare @str nvarchar(max)
set @str=”
select @str=@str+isnull(name+’,',”) from CriminalUser WHERE criminal_id=13
PRINT @str
declare @str nvarchar(max)
set @str=”
select @str=@str+isnull(name+’,',”) from CriminalUser WHERE criminal_id=13
PRINT @str
