SQLserver存储过程procedure

创建 CREATE procedure

CREATE procedure Proc_SC @sid char(16)
AS
BEGINSELECT 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
BEGINSELECT 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
BEGINDELETE FROM StudentWHERE id = @sid;DELETE FROM StudentCourse WHERE sid = @sid;
END