create function fnTest1() returns table as return select 1 as 'a', 2 as 'b', 3 as 'c' union all select 2 as 'a', 2 as 'b', 3 as 'c' union all select 3 as 'a', 2 as 'b', 3 as 'c' go create function fnTest2() returns table as return select * from test.dbo.fnTest1() goselect * from dbo.fnTest2() godrop function fnTest1 go drop function fnTest2 go
set @rr=dbo.fn_name(...)一定要加dbo.
returns table
as
return select 1 as 'a', 2 as 'b', 3 as 'c'
union all select 2 as 'a', 2 as 'b', 3 as 'c'
union all select 3 as 'a', 2 as 'b', 3 as 'c'
go create function fnTest2()
returns table
as
return select * from test.dbo.fnTest1()
goselect * from dbo.fnTest2()
godrop function fnTest1
go
drop function fnTest2
go