spLoadRecord_DiscussionTopics
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@PKID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spLoadRecord_DiscussionTopics
(
@PKID int
)
AS
select DiscussionTopics.ID,Topic,PostedByID,
dbo.fnUserName(DiscussionTopics.PostedByID) as [FullName],
Replies,LastPostDate,GroupID,Approved,DiscussionTopics.Guid
from DiscussionTopics
where DiscussionTopics.ID = @PKID