TopicID(主键) | ... | QuestionID |
表Question
QuestionID(主键) | ..... | TopicID(外键) |
表Answer
AnswerID(主键) | ..... | QuestionID外键) |
现在想通过TopicID删除所有关联的数据记录:
用存储过程:过程如下:
CREATE PROC DELETEDATA
(
@TOPICID INTERGE (4)
)
AS
BEGIN
DELETE FROM TOPIC WHERE TOPICID = @TOPICID,
DELETE FROM QUESTION WHERE TOPICID = @TOPICID,
DELETE FORM ANSWER WHERE )QUESTIONID = ANY(SELCET QUESTIONID FROM QUESTION WHERE (TOPICID = @TOPICID )) )
END
RETURN
///CS中存储过程的基本借鉴用法
cmdUpdPubs = new SqlCommand();
cmdUpdPubs.Connection = cnPubs;
cmdUpdPubs.CommandType = CommandType.StoredProcedure;
cmdUpdPubs.CommandText = "up_UpdatePublisherName";
// 为上面的SqlCommand对象添加必要的参数
cmdUpdPubs.Parameters.Add( "@pub_id", SqlDbType.Char, 4, "pub_id" );
cmdUpdPubs.Parameters.Add( "@pub_name", SqlDbType.VarChar, 40, "pub_name" );