存储过程、触发器的例子.doc

存储过程： 1.CREATE PROCEDURE loving AS BEGIN SELECT * from student where ssex='女' END： 执行 Exec loving 2. CREATE PROCEDURE loving1 as BEGIN SELECT * from student end 3. CREATE PROCEDURE pr1_sc_ins @Param1 char(10),@Param2 char(2),@Param3 real AS BEGIN insert into sc(sno,cno,grade) values(@Param1,@Param2,@Param3) END 执行: EXEC pr1_sc_ins '200215121','4',85或 EXEC pr1_sc_ins @Param1='200215121',@Param2='6', @Param3=85 4. CREATE PROCEDURE s_grade @sname char(8),@sgrade real output AS SELECT @sgrade =grade from sc join student on student.sno=sc.sno where sname=@sname 执行： DECLARE @sgrade real EXEC s_grade @sname = '李勇', @sgrade = @sgrade OUTPUT