spApprove_JobPost
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @CurrentUsersID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spApprove_JobPost]
(
@PKID int ,
@CurrentUsersID int
)
AS
set nocount on
begin transaction
UPDATE JobPosts set APPROVED = 1, ApprovedID = @CurrentUsersID, ApprovedDate = getutcdate()
where ID = @PKID
commit transaction