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