create procedure pro_topPercent  
( 
 @ipercent [int] =0        --默认不返回 
) 
as 
begin 
select top (@ipercent ) percent * from books 
end 

create procedure pro_topPercent  
( 
 @ipercent [int] =0  
) 
as 
begin 
select top((select COUNT (*) from books)*(@ipercent)/100) * from books 
end 
exec pro_topPercent '10'    --执行存储过程

declare @studentname_1 
 
exec myprocedure