SQLServer -- 自定义无参数存储过程_sqlserver 存储过程无参数

自定义储过程

use StuManageDB
go
if exists(Select * from sysobjects where name='usp_ScoreQuery')
drop procedure usp_ScoreQuery
go

create procedure usp_ScoreQuery --创建存储过程
as
    --查询考试信息
    select Students.StudentId,StudentName,ClassName,ScoreSum=(CSharp+SQLServerDB)
    from Students
    inner join StudentClass on Students.ClassId = StudentClass.ClassId
    inner join ScoreList on Students.StudentId = ScoreList.StudentId
    order by ScoreSum DESC

go
ex
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17