spDelete_NewsChannels
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @CurrentUsersID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spDelete_NewsChannels
(
@PKID int ,
@CurrentUsersID int
)
AS
begin transaction
DECLARE @SiteContentID int
SELECT @SiteContentID = SiteContentID FROM NewsChannels where ID = @PKID
DELETE FROM Search where SiteContentID = @SiteContentID
DELETE FROM NewsChannels where ID = @PKID
commit transaction