asp.net - 如何执行两个更新语句

Question

    ALTER PROCEDURE dbo.ModeratorSpamDeleteThread

  @ThreadsID INT

AS

  DELETE Threads
  WHERE ThreadsID=@ThreadsID

我有这个..但它告诉我我无法删除该表，因为它通过外键连接到另一个表..

所以我也需要这样做:

  @ThreadsID INT

AS

  DELETE Comments
  WHERE ThreadsID=@ThreadsID

问题是我如何将两个stamtents合二为一？

Answer 1

您首先在注释中执行删除，然后在线程中执行删除。

ALTER PROCEDURE dbo.ModeratorSpamDeleteThread
  @ThreadsID INT
AS

DELETE Comments
WHERE ThreadsID=@ThreadsID 

DELETE Threads
WHERE ThreadsID=@ThreadsID