自定义函数

create function getcount5
(@dname char(30)
)
returns int
as
begin
declare @count int
select @count=count(student.sno)
from student,dept
where dept.dname=@dname and student.dno=dept.dsno
return @count
end

declare @count int
exec @count=getcount5 @dname='eng'
print convert(char(10),@count)

create function teacher_info1
(@tname char(30)
)
returns table
as
return
(select tname,tsex,tbirthday
from teacher_info
where tname=@tname
)

select * from teacher_info1('zhang')

drop function getcount
drop function teacher_info2