CREATE PROCEDURE Input_Score 
	@yearno char(4),
	@termno char(2),
	@classno char(10),
	@courseno char(10),
	@achievetype char(10),
	@startNo char(10),
	@Endno char(10)
AS
	declare @cno char(10)	
	declare @cnt int
	select @cno = γ̺ from course where rtrim(course.γ) = rtrim(@courseno)

	if len(rtrim(@startno)) = 0
	begin
  		select  @cnt = count(*)  from achievement 
			where ѧ in (select student.ѧ from student where rtrim() = @classno) and ѧ=@termno and ѧ=@yearno and rtrim(γ̺) = rtrim(@cno)
		if @cnt <= 0
		  insert achievement ( ѧ,,γ̺,ѧ,ѧ)
		       select student.ѧ,student.,@cno,@yearno,@termno from student where rtrim(student.) = rtrim(@classno)

		if @achievetype="гɼ"
			select ѧ,,γ̺,@courseno,ѧ,ѧ,гɼ from achievement
				where ѧ in (select student.ѧ from student where rtrim() = @classno) and ѧ=@termno and ѧ=@yearno and rtrim(γ̺) = rtrim(@cno)
		else
		if @achievetype="ĩɼ"
			select ѧ,,γ̺,@courseno,ѧ,ѧ,ĩɼ from achievement
				where ѧ in (select student.ѧ from student where rtrim() = @classno) and ѧ=@termno and ѧ=@yearno and rtrim(γ̺) = rtrim(@cno)
		else
		if @achievetype="ƽʱɼ"
			select ѧ,,γ̺,@courseno,ѧ,ѧ,ƽʱɼ from achievement
				where ѧ in (select student.ѧ from student where rtrim() = @classno) and ѧ=@termno and ѧ=@yearno and rtrim(γ̺) = rtrim(@cno)
		else

		if @achievetype="ɼ"
			select ѧ,,γ̺,@courseno,ѧ,ѧ,ɼ from achievement
				where ѧ in (select student.ѧ from student where rtrim() = @classno) and ѧ=@termno and ѧ=@yearno and rtrim(γ̺) = rtrim(@cno)
		else
		if @achievetype="ɼ"
			select ѧ,,γ̺,@courseno,ѧ,ѧ,ɼ from achievement
				where ѧ in (select student.ѧ from student where rtrim() = @classno) and ѧ=@termno and ѧ=@yearno and rtrim(γ̺) = rtrim(@cno)
	end
	else
	begin
		select  @cnt = count(*)  from achievement 
			where rtrim(ѧ) <= rtrim(@Endno) and rtrim(ѧ) >= rtrim(@startNo) and ѧ=@termno and ѧ=@yearno and rtrim(γ̺) = rtrim(@cno)
		if @cnt <= 0
		insert achievement ( ѧ,,γ̺,ѧ,ѧ)
		       select student.ѧ,student.,@cno,@yearno,@termno from student where  rtrim (student.ѧ) <= rtrim(@Endno) and rtrim(student.ѧ) >= rtrim(@startNo)


		if @achievetype="гɼ"
			select ѧ,,γ̺,@classno,ѧ,ѧ,гɼ from achievement
			where rtrim(ѧ) <= rtrim(@Endno) and rtrim(ѧ) >= rtrim(@startNo) and ѧ=@termno and ѧ=@yearno and rtrim(γ̺) = rtrim(@cno)		
		else
		if @achievetype="ĩɼ"
			select ѧ,,γ̺,ѧ,ѧ,ĩɼ from achievement
			where rtrim(ѧ) <= rtrim(@Endno) and rtrim(ѧ) >= rtrim(@startNo) and ѧ=@termno and ѧ=@yearno and rtrim(γ̺) = rtrim(@cno)		
		else
		if @achievetype="ƽʱɼ"
			select ѧ,,γ̺,ѧ,ѧ,ƽʱɼ from achievement
			where rtrim(ѧ) <= rtrim(@Endno) and rtrim(ѧ) >= rtrim(@startNo) and ѧ=@termno and ѧ=@yearno and rtrim(γ̺) = rtrim(@cno)		
		else

		if @achievetype="ɼ"
			select ѧ,,γ̺,ѧ,ѧ,ɼ from achievement
			where rtrim(ѧ) <= rtrim(@Endno) and rtrim(ѧ) >= rtrim(@startNo) and ѧ=@termno and ѧ=@yearno and rtrim(γ̺) = rtrim(@cno)
		else
		if @achievetype="ɼ"
			select ѧ,,γ̺,ѧ,ѧ,ɼ from achievement
			where rtrim(ѧ) <= rtrim(@Endno) and rtrim(ѧ) >= rtrim(@startNo) and ѧ=@termno and ѧ=@yearno and rtrim(γ̺) = rtrim(@cno)

	end
	








