摘要：创建自定义函数create function getNameById (@tid int)returns varchar(100)asbegindeclare @tname varchar(100)select @tname=teacher_name from t_teacher_info where teacher_id=@tidreturn @tnameend-------------------------------------------------------------------------------------------调用自定义函数select *,dbo.getNam 阅读全文