updatesubject.sql

来自「一个别人编写的学生管理系统,开以看下」· SQL 代码 · 共 25 行

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'UpdateSubject')
	BEGIN
		DROP  Procedure  UpdateSubject
	END

GO

CREATE Procedure UpdateSubject
@SubjectName varchar(50),
@Remark varchar(256),
@SubjectId int
AS
UPDATE T_Subject
SET SubjectName = @SubjectName, Remark = @Remark
WHERE (SubjectId = @SubjectId)

GO

/*
GRANT EXEC ON UpdateSubject TO PUBLIC

GO
*/