use StudentManager

 go

 if exists(select * from sysobjects where name='usp_ScoreQuery2')

 drop procedure usp_ScoreQuery2

 go

 --创建带参数的存储过程

 create procedure usp_ScoreQuery2

 @CSharp int,

 @DB int

 as

     select Students.StudentId,StudentName,C#=CSharp,DB=SQLServerDB

     from Students

     inner join ScoreList on Students.StudentId=ScoreList.StudentId

     where CSharp<@CSharp or SQLServerDB<@DB

 go

 --调用带参数的存储过程

 exec usp_ScoreQuery2 60,65 --按照参数顺序赋值

 exec usp_ScoreQuery2 @DB=65,@CSharp=60 --参数顺序可以调换

 use StudentManager

 go

 if exists(select * from sysobjects where name='usp_ScoreQuery3')

 drop procedure usp_ScoreQuery3

 go

 --创建带参数的存储过程

 create procedure usp_ScoreQuery3

 @CSharp int=60,

 @DB int=60

 as

     select Students.StudentId,StudentName,C#=CSharp,DB=SQLServerDB

     from Students

     inner join ScoreList on Students.StudentId=ScoreList.StudentId

     where CSharp<@CSharp or SQLServerDB<@DB

 go

 --调用带参数的存储过程

 exec usp_ScoreQuery3 65 --第二个参数没有赋值，则默认

 exec usp_ScoreQuery3 @DB=65

 exec usp_ScoreQuery3 default,65 --不使用显示方式赋值

 exec usp_ScoreQuery3   --两个参数都是用默认参数