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