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 '不能将其删除...

JDBC驱动汇总关键字 JDBC 有鉴于许多版友对于寻找JDBC driver或者如何使用driver常常发问,在这边我简单整理一下比较代表性的driver跟使用方式.Microsoft SQL Server series (6.5, 7.x, 2000 and 2005) and Sybase 10JDBC Name: jTDSURL: http://jtds.sourceforge.net/Version: 0.5.1Download URL: http://sourceforge.net/project/showfiles.php?group_id=33291语法:Class....