create function getstr(@字段i varchar(10))
returns Nvarchar(1000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+'+'+cast(charge as varchar(10)) from [table] where 字段i=@字段i
set @str=right(@str,len(@str)-1)
return @str
end
go---调用:
select id,dbo.getstr(id) charge from [table]
returns Nvarchar(1000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+'+'+cast(charge as varchar(10)) from [table] where 字段i=@字段i
set @str=right(@str,len(@str)-1)
return @str
end
go---调用:
select id,dbo.getstr(id) charge from [table]
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货