摘要： create view dbo.work_yearswithschemabindingasselect top 100 percent emp_id,e_name, birthday, hire_date, year(getdate())- year(hire_date) as work_yearsfrom dbo.employeeorder by work_years desccreate unique clusteredindex emp_id_view on dbo.work_years (emp_id) 阅读全文