SQLserver存储过程procedure

创建 ​​CREATE procedure​​

CREATE procedure Proc_SC @sid char(16)
AS
BEGIN
  SELECT NAME FROM Course Where ID IN (SELECT CourseID FROM CourseSelection WHERE SID = @sid)
END

执行

Proc_SC '974391'

修改

ALTER PROCEDURE Proc_SC @sid char(16)
AS
BEGIN
  SELECT NAME AS 课程名 FROM Course Where ID IN (SELECT CourseID FROM CourseSelection WHERE SID = @sid)
END

删除
​​​DROP PROCEDURE dbo.xxx​​

if EXISTS (SELECT * FROM sys.procedures p WHERE p.name = 'Proc_SC')
BEGIN 
  DROP PROCEDURE dbo.Proc_SC
END

stu_proc '2F42BF3F-C5C8-4D14-B693-0B60573F4671'

--创建一个存储过程 删除传入id项和对应选课的表中的选课记录
ALTER PROCEDURE stu_proc @sid uniqueidentifier
AS
BEGIN
  DELETE FROM Student
  WHERE id = @sid;
  DELETE FROM StudentCourse 
  WHERE sid = @sid;
END