函数返回表

create function test (@lb varchar(20))

returns @temp table

(lieming varchar(20),xianshi varchar(20),tablename varchar(20))
as
begin
declare @lieming varchar(20),@xianshi varchar(20),@tablename varchar(20)

if (@lb='') set @lb='khlb'
 if ( @lb='khlb' )begin select @lieming='Cus_type',@xianshi='客户类别',@tablename='customer' end 
else if ( @lb='khzt' )begin select @lieming='Cus_tag',@xianshi='客户状态',@tablename='customer' end 
else if ( @lb='xxly' )begin select @lieming='Souce',@xianshi='信息来源',@tablename='customer' end 
insert into @temp(lieming,xianshi,tablename)
select @lieming lieming,@xianshi xianshi,@tablename tablename

return
end

调用
Select * from  test ('')