USE [student]GO/****** 对象: StoredProcedure [dbo].[st_jsjbj] 脚本日期: 06/22/2010 21:06:07 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[st_jsjbj]ASSELECT 班级名称 FROM 班级 WHERE 系部代码 = (SELECT 系部代码 FROM 系部WHERE 系部名称='计算机系')

USE [Students]GO/****** 对象: Trigger [del_stu1] 脚本日期: 06/22/2010 20:36:33 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate trigger [del_stu1] on [dbo].[学生表]for delete asdeclare @xuehao intselect @xuehao=学号 from Deletedif exists(select *from 课程注册表 where 学号=@xuehao) beginprint '不能将其删除...