insertsubject.sql

一个别人编写的学生管理系统,开以看下

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

GO

CREATE Procedure InsertSubject
@SubjectName varchar(50),
@Remark varchar(256)
AS

INSERT INTO T_Subject
      (SubjectName, Remark)
VALUES (@SubjectName,@Remark)
GO

/*
GRANT EXEC ON InsertSubject TO PUBLIC

GO
*/