存储过程加密

 

/*返回老师管理下所有学生数*/

create procedure proc_sum_student

   @teacher_id int ,@sum_student int output

as

 select    @sum_student=count(id)     ---count是统计函数

 from    student

 where

        teacher_id = @teacher_id

go

 

/*输入老师编号*/

declare @sum_student   int      ---@sum_student为声明的变量

execute proc_sum_student   102,@sum_student

go

 

/*将存储过程proc_insert_student加密*/

use   school

go

alter   procedure    proc_insert_student

    @id int,

    @name char(30),

    @gender char(2),

    @age int,

    @grade smallint,

    @class smallint,

    @teacher_id int,

    @parents_id int,

    @graduation char(20),

    @city char(10),

    @cardno char(20)

with encryption

as

   insert   into student            (id,name,gender,age,grade,class,teacher_id,parent_id,graduation,city,cardno)

values            (@id,@name,@gender,@age,@grade,@class,@teacher_id,@parents_id,@graduation,@city,@cardno)