The following stored procedure returns all employees (first and last names supplied), their job titles, and their department names from a view.

• 以下存储过程将从视图中返回所有雇员(提供姓和名)、职务以及部门名称。