建立视图的语句如下
CREATE view view_ttt as
select nUserid,dbo.f_hb(nUserid) as nTrade from tb_Person_Job
group by nUseridf_hb的函数如下
create function f_hb(@nuserid int)
returns varchar(50)
as
begin
declare @str varchar(50)
set @str = ''
select @str = @str + ',' + cast(ntrade as varchar) from (select distinct ntrade from tb_Person_Job where nuserid = @nuserid) t
set @str = right(@str , len(@str) - 1)
return(@str)
End
CREATE view view_ttt as
select nUserid,dbo.f_hb(nUserid) as nTrade from tb_Person_Job
group by nUseridf_hb的函数如下
create function f_hb(@nuserid int)
returns varchar(50)
as
begin
declare @str varchar(50)
set @str = ''
select @str = @str + ',' + cast(ntrade as varchar) from (select distinct ntrade from tb_Person_Job where nuserid = @nuserid) t
set @str = right(@str , len(@str) - 1)
return(@str)
End
(select nUserid from tb_Person_Job
group by nUserid)tmp
------------------------------------------------------------------
换成
select @str = @str + ',' + cast(ntrade as varchar) from tb_Person_Job where nuserid = @nuserid group by ntrade
SELECT *
FROM view_ttt
WHERE (nTrade = '001')还是提示超时已过期.