存储过程

CREATE proc [dbo].[sp_Feedback]
(
@feedbackID int=0 out,
@replyToID int=0, 
@title varchar(100)=null,
@isPublish bit=0,
@action int=0 --1 insert 2 update 3delete 4select(id)
) 
 
AS
IF @action = 1 
BEGIN
 INSERT INTO Feedback(
[replyToID],[title],[isPublish])VALUES(
        @replyToID,@title,@isPublish)
END 
else if @action = 2 
BEGIN 
    UPDATE Feedback SET
    [replyToID] = @replyToID,[title]=@title,[isPublish]=@isPublish
    WHERE [feedbackID]=@feedbackID
END
else if @action = 3
BEGIN 
    DELETE Feedback WHERE [feedbackID]=@feedbackID
END

else if @action = 4
BEGIN 
    Select [feedbackID],[replyToID],[title],[isPublish] From Feedback
 WHERE [feedbackID]=@feedbackID
END