spDelete_DiscussionGroups
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @CurrentUsersID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spDelete_DiscussionGroups
(
@PKID int ,
@CurrentUsersID int
)
AS
begin transaction
DECLARE @SiteContentID int
SELECT @SiteContentID = SiteContentID
FROM DiscussionGroups g
WHERE g.[id] = @PKID
DELETE FROM Search WHERE SiteContentID = @SiteContentID
DELETE FROM DiscussionGroups where ID = @PKID
commit transaction