ALTER PROCEDURE [dbo].[Paper_GetAlreadyCheckedNum]
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
@college nvarchar(30)
AS
/* SET NOCOUNT ON */
if @college = '研究生院'
begin
select count(*) from Paper where IfChecked='是'
end
else
begin
select count(*) from Paper where IfChecked='是' and College=@college
end
RETURN