create function getstr1(@id Nchar(10)) returns Nvarchar(2000) as begin declare @str Nvarchar(2000) set @str=N'' select @str=@str+rtrim(m1m) from 表 where hao=@id return @str end GOcreate function getstr1(@id Nchar(10)) returns Nvarchar(2000) as begin declare @str Nvarchar(2000) set @str=N'' select @str=@str+rtrim(m2m) from 表 where hao=@id return @str end GO-------------------- select hao,dbo.getstr1(hao) m1m,dbo.getstr2(hao) m2m,sum(money) total from 表 group by hao
returns Nvarchar(2000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+rtrim(m1m) from 表
where hao=@id
return @str
end
GOcreate function getstr1(@id Nchar(10))
returns Nvarchar(2000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+rtrim(m2m) from 表
where hao=@id
return @str
end
GO--------------------
select hao,dbo.getstr1(hao) m1m,dbo.getstr2(hao) m2m,sum(money) total
from 表
group by hao
那个m1m和m2m字段是Text类型的,怎么办?报错说不能用rtrim函数!
这里有老龟奴zyq_123雍亲正当大版主,还有人称辣花摧魔前青楼名妓smoke当镇小版主,肯定能满足您的需要!!!快来吧~~~~~~