作者在 2010-06-22 21:07:02 发布以下内容
USE [student]
GO
/****** 对象: StoredProcedure [dbo].[st_jsjbj] 脚本日期: 06/22/2010 21:06:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[st_jsjbj]
AS
SELECT 班级名称 FROM 班级
WHERE 系部代码 = (SELECT 系部代码 FROM 系部
WHERE 系部名称='计算机系')
GO
/****** 对象: StoredProcedure [dbo].[st_jsjbj] 脚本日期: 06/22/2010 21:06:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[st_jsjbj]
AS
SELECT 班级名称 FROM 班级
WHERE 系部代码 = (SELECT 系部代码 FROM 系部
WHERE 系部名称='计算机系')