存储过程、触发器的例子2(1)文.pdfVIP

  • 2
  • 0
  • 约1.55万字
  • 约 12页
  • 2021-11-15 发布于福建
  • 举报
存储过程: 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_g

您可能关注的文档

文档评论(0)

1亿VIP精品文档

相关文档