Question

用SQL 语句创建存储过程proc1，功能是统计某院系学生人数。

用SQL 语句创建存储过程proc1，功能是统计某院系学生人数。
数据库名称：stuDatabase
数据表：Student(StuNo,StuName,SteSex,StuCollege)

Answer 1

create proc p(@StuCollege nvarchar(50))
as
select count(*) as 人数 from Student where StuCollege=@StuCollege

go
--

Answer 2

use stuDatabase
go
create proc procName
as
select count(stucollege) from student group by stucollege

Answer 3

sum StuNo from StuCollege
where StuCollege in(某院)

很久没用过了，记不太清楚了
应该是这样的