学生成绩数据库设计 五 执行存储过程

EXEC SelectScores ‘2010-10‘

EXEC SelectCjPaiming ‘2011-10‘,‘课程3‘

1 DECLARE @strOutPut nvarchar(200)
2 BEGIN
3     EXEC UpdateStuState 2012,2013,@strOutPut OUTPUT
4     IF(@strOutPut IS NOT NULL)
5         begin
6             print @strOutPut
7         end
8 END

DECLARE @strOutPut nvarchar(200)
BEGIN
    EXEC StatScoreDetail 2012,2013,@strOutPut OUTPUT
    IF(@strOutPut IS NOT NULL)
        begin
            print @strOutPut
        end
END