--函数
create function get_str(@id int)
returns varchar(2000)
as
begin
declare @r varchar(2000)
set @r=''
select @r=@r+txt from ta where id=@id
return @r
endgo--调用
select id,dbo.getstr(id) as stxt
from (
select distinct id from ta
) as x
create function get_str(@id int)
returns varchar(2000)
as
begin
declare @r varchar(2000)
set @r=''
select @r=@r+txt from ta where id=@id
return @r
endgo--调用
select id,dbo.getstr(id) as stxt
from (
select distinct id from ta
) as x
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货