内嵌表值函数 调用的问题？

[zhangxi87]

create table employee
(
em_id int not null primary key,
em_name varchar(20) not null,
salary money not null
)
Go
create function salary(@id int)
returns table as
return(select * from employee where em_id = @id)


Go
select temp1.dbo.salary(1)

显示对象名无效

[-狙击手-]

create function f_stock(@bom_head varchar(20))
returns @t table(bom varchar(20),number int)
as
。。。。。。
Go

[playwarcraft]

Go
select temp1.dbo.salary(1)
===================================
改為

select * from temp1.dbo.salary(1) T

[playwarcraft]

你的function返回的是一個table，
直接select table,當然報錯

[zhangxi87]

Thank you everybody!!!!