函数-生成临时表
create function ufn_emp(@vcity nvarchar(15))
returns @emptab table
(
fname char(10),
lname char(10)
)
begin
insert @emptab select firstname,lastname
from employees where city=@vcity
return
end
//应用
select * from ufn_emp(''seattle'')