上面有点错:
create function getresult(@标识号 varchar(10))
returns varchar(100)
as
begin
declare @result varchar(100)
set @result=''
select @result=@result+备注 from yourtable where 标识号=@标识号
return @result
end
语句:
select distinct 标识号,dbo.getresult(标识号) from yourtable
create function getresult(@标识号 varchar(10))
returns varchar(100)
as
begin
declare @result varchar(100)
set @result=''
select @result=@result+备注 where 标识号=@标识号
return @result
end
语句:
select distinct 标识号,dbo.getresult(标识号) from table