第一回用存储进程，求解惑

第一次用存储进程，求解惑
这是添加数据的一个存储进程：

SQL code

CREATE PROCEDURE [dbo].[Proc_UserPaperList]AS SELECT distinct    [dbo].[Users].[UserID],                 [dbo].[Users].[UserName],                          [dbo].[Users].[DepartmentId],                          [dbo].[Department].[DepartmentId],                           [dbo].[Department].[DepartmentName],        [dbo].[UserAnswer].[UserID],        [dbo].[UserAnswer].[PaperID],        [dbo].[UserAnswer].[ExamTime],        [dbo].[Paper].[PaperName],                           [dbo].[Paper].[PaperState] as stateFROM         [dbo].[Users],[dbo].[Department],[dbo].[UserAnswer],[dbo].[Paper]where Users.DepartmentId=Department.DepartmentId and Users.UserID=UserAnswer.UserID and UserAnswer.PaperID=Paper.PaperIDGO

SQL code

create procedure p_delete(@userid nvarchar(50),@paperid nvarchar(50))asbegin delete from user where userid=@userid ; delete from paper where paperid=@paperid; end