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

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！