declare @fulltext nvarchar(4000)
set @fulltext=''
select @fulltext=@fulltext+treestruttext+'/' from xzstruct
where layerType=5 and isdel is null and structName like '佛山%'
sqlserver 把结果集拼成一行字符串
最新推荐文章于 2023-03-07 09:29:25 发布
declare @fulltext nvarchar(4000)
set @fulltext=''
select @fulltext=@fulltext+treestruttext+'/' from xzstruct
where layerType=5 and isdel is null and structName like '佛山%'