use xiketangtest
go
if exists (select * from sysobjects where name ='usp_mystoreprocedure')
drop procedure usp_mystoreprocedure
go
create procedure usp_mystoreprocedure--创建存储过程
as
select studentname ...
from...
inner join...
group by...
go
execute usp_mystoreprocedure