Session 14

1. CREATE PROCEDURE Get_Sales_Avg
@author varchar(11)
AS
select avg(a.ytd_sales) as 'Trung binh year-to-day sale' from titles a, titleauthor b
where b.title_id=a.title_id and b.au_id=@author
go
2. exec get_sales_avg '267-41-2394' with recompile
3. sp_stored_procedures
4. sp_helptext get_sales_avg