级联表中数据的删除

表Topic

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" );