--4:删除问卷
CREATE PROC [Questionaire].[DeleteQuestionaire]
@questionaireID INT
AS
BEGIN TRAN;
BEGIN TRY
--删除问卷基本题目
DELETE QuestionairesBasicQuestions WHERE QuestionaireID = @QuestionaireID
--删除问卷分段
DELETE QuestionairesSections WHERE QuestionaireID = @QuestionaireID
--删除问卷题目
DELETE QuestionairesQuestions WHERE QuestionaireID = @QuestionaireID
--删除问卷
DELETE Questionaires WHERE QuestionaireID = @QuestionaireID;
COMMIT TRAN;
END TRY
BEGIN CATCH
ROLLBACK TRAN;
END CATCH
---EXEC [Questionaire].[GetQuestionaires] @CurrentPage,@PageSize
GO
本文介绍了一个用于删除问卷的数据库存储过程，包括删除问卷的基本题目、分段、题目和问卷本身。该过程通过事务处理确保数据操作的一致性和完整性。
扫一扫
425
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
