declare @str nvarchar(1000)
set @str = ”
select @str = @str + dept_name + ‘;’ from sc_sys_dept_hosp where comp_code=’101’
select @str
输出结果:A;B;C;
declare @str nvarchar(1000)
set @str = ”
select @str = @str + dept_name + ‘;’ from sc_sys_dept_hosp where comp_code=’101’
select @str
输出结果:A;B;C;