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 ('')