存储过程、触发器的例子.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(@Para