create function f_str()
returns varchar(8000)
as
begin
declare @str varchar(8000)
select @str=isnull(@str,'')+','+staff
from a where level=2
reutrn stuff(@str,1,1,'')
end
go--更新
update a
set fore=dbo.f_str()
where level=1
returns varchar(8000)
as
begin
declare @str varchar(8000)
select @str=isnull(@str,'')+','+staff
from a where level=2
reutrn stuff(@str,1,1,'')
end
go--更新
update a
set fore=dbo.f_str()
where level=1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货