存储过程加密

 

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

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)